اول - با عرض معذرت فراوان، هر كاري كردم براي ضميمه ي فايلها در همين قسمت نمي شد. حجمشون هم از حد مجاز كمتر بود ولي نشد به ناچار يه جاي ديگه گذاشتم. باز هم تلاش مي كنم. با تشكر از پي گيري شما.
كدهاي مربوط به همين دستورات رو كه در كلاسهاي جدا نوشتم، ببينيد لطفا:
DAL - Details
using System;
using System.Collections.Generic;
using System.Text;
namespace Haser_App.DAL
{
public class EmploeeDetails
{
public EmploeeDetails() { }
public EmploeeDetails(int nid,string id, string name, string family, string fname, string idno, string nidno,
string bdate, string phone, string mobile, string address, string mail, bool pic,bool present,
string lastcert,string lastcertdate,string diplomdate,string tahol,string childno,string khedmat,
string takafol,string grade,string start,string remark,string username,string pass,bool usertype)
{
this.nID = nid;
this.UserID = id;
this.UserName = name;
this.UserFamily = family;
this.UserFatherName = fname;
this.UserIdentificationNo = idno;
this.UserNationalCode = nidno;
this.UserBirthDate = bdate;
this.UserPhoneNo = phone;
this.UserMobileNo = mobile;
this.UserAddress = address;
this.UserEmailAddress = mail;
this.HasPicture = pic;
this.LastCertification = lastcert;
this.LastCertificationDate = lastcertdate;
this.DiplomeDate = diplomdate;
this.Taahol = tahol;
this.ChildrenNo = childno;
this.Khedmat = khedmat;
this.Takafol = takafol;
this.Organizationgrade = grade;
this.StartDate = start;
this.Remark = remark;
this.IsPresent = present;
this.UserLogName = username;
this.UserLogPassword = pass;
this.IsAdmin = usertype;
}
#region "Private Fields"
private int _nid = 0;
private string _id = "";
private string _name = "";
private string _family = "";
private string _fname = "";
private string _idno = "";
private string _nidno = "";
private string _bdate = "";
private string _phone = "";
private string _mobile = "";
private string _address = "";
private string _mail = "";
private bool _pic = false;
private bool _present = false;
private string _lastcert = "";
private string _lastcertdate = "";
private string _diplomedate = "";
private string _tahol = "";
private string _childno = "";
private string _khedmat = "";
private string _takafol = "";
private string _grade = "";
private string _start = "";
private string _remark = "";
private string _username = "";
private string _password = "";
private bool _usertype = false;
#endregion
#region "Public Peropery"
public int nID
{
get { return _nid; }
set { _nid = value; }
}
public string UserID
{
get { return _id; }
set { _id = value; }
}
public string UserName
{
get { return _name; }
set { _name = value; }
}
public string UserFamily
{
get { return _family; }
set { _family = value; }
}
public string UserFatherName
{
get { return _fname; }
set { _fname = value; }
}
public string UserIdentificationNo
{
get { return _idno; }
set { _idno = value; }
}
public string UserNationalCode
{
get { return _nidno; }
set { _nidno = value; }
}
public string UserBirthDate
{
get { return _bdate; }
set { _bdate = value; }
}
public string UserPhoneNo
{
get { return _phone; }
set { _phone = value; }
}
public string UserMobileNo
{
get { return _mobile; }
set { _mobile = value; }
}
public string UserAddress
{
get { return _address; }
set { _address = value; }
}
public string UserEmailAddress
{
get { return _mail; }
set { _mail = value; }
}
public bool HasPicture
{
get { return _pic; }
set { _pic = value; }
}
public bool IsPresent
{
get { return _present; }
set { _present = value; }
}
public string LastCertification
{
get { return _lastcert; }
set { _lastcert = value; }
}
public string LastCertificationDate
{
get { return _lastcertdate; }
set { _lastcertdate = value; }
}
public string DiplomeDate
{
get { return _diplomedate; }
set { _diplomedate= value; }
}
public string Taahol
{
get { return _tahol; }
set { _tahol = value; }
}
public string ChildrenNo
{
get { return _childno; }
set { _childno = value; }
}
public string Khedmat
{
get { return _khedmat; }
set { _khedmat = value; }
}
public string Takafol
{
get { return _takafol; }
set { _takafol = value; }
}
public string Organizationgrade
{
get { return _grade; }
set { _grade = value; }
}
public string StartDate
{
get { return _start; }
set { _start = value; }
}
public string Remark
{
get { return _remark; }
set { _remark = value; }
}
public string UserLogName
{
get { return _username; }
set { _username = value; }
}
public string UserLogPassword
{
get { return _password; }
set { _password = value; }
}
public bool IsAdmin
{
get { return _usertype; }
set { _usertype = value; }
}
#endregion
}
}
DAL - DataAccess
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.Windows.Forms;
using Haser_App.DAL;
namespace Haser_App.DAL.Sql
{
public class emploeeDataAccess
{
protected string connectionString = "";
private string error = Haser_App.Properties.Resources.InsertError;
public emploeeDataAccess()
{
connectionString = Haser_App.Properties.Settings.Default.conStr;
}
public void InsertNewEmploee(EmploeeDetails objEmploee)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] param = new SqlParameter[14];
param[0] = new SqlParameter("@u_vid", SqlDbType.NVarChar);
param[0].Value = objEmploee.UserID;
param[1] = new SqlParameter("u_name", SqlDbType.NVarChar);
param[1].Value = objEmploee.UserName;
param[2] = new SqlParameter("@u_family", SqlDbType.NVarChar);
param[2].Value = objEmploee.UserFamily;
param[3] = new SqlParameter("@u_fathername", SqlDbType.NVarChar);
param[3].Value = objEmploee.UserFatherName;
param[4] = new SqlParameter("@u_idno", SqlDbType.NVarChar);
param[4].Value = objEmploee.UserIdentificationNo;
param[5] = new SqlParameter("@u_nidno", SqlDbType.NVarChar);
param[5].Value = objEmploee.UserNationalCode;
param[6] = new SqlParameter("@u_birthdaydate", SqlDbType.NVarChar);
param[6].Value = objEmploee.UserBirthDate;
param[7] = new SqlParameter("@u_phone", SqlDbType.NVarChar);
param[7].Value = objEmploee.UserPhoneNo;
param[8] = new SqlParameter("@u_mobile", SqlDbType.NVarChar);
param[8].Value = objEmploee.UserMobileNo;
param[9] = new SqlParameter("@u_address", SqlDbType.NVarChar);
param[9].Value = objEmploee.UserAddress;
param[10] = new SqlParameter("@u_mail", SqlDbType.NVarChar);
param[10].Value = objEmploee.UserEmailAddress;
param[11] = new SqlParameter("@u_haspic", SqlDbType.Bit);
param[11].Value = objEmploee.HasPicture;
param[12] = new SqlParameter("@u_present", SqlDbType.Bit);
param[12].Value = objEmploee.IsPresent;
param[13] = new SqlParameter("@u_id", SqlDbType.Int);
param[13].Value = objEmploee.nID;
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "sp_addEmploee", param);
}
catch (Exception ex)
{
MessageBox.Show(error + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
finally
{
connection.Close();
}
}
}
public void InsertNewEmploeeDetails(EmploeeDetails objEmploee)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@u_vid", SqlDbType.NVarChar);
param[1] = new SqlParameter("@u_lastcert", SqlDbType.NVarChar);
param[2] = new SqlParameter("@u_lastcertdate", SqlDbType.NVarChar);
param[3] = new SqlParameter("@u_diplomdate", SqlDbType.NVarChar);
param[4] = new SqlParameter("@u_tahol", SqlDbType.NVarChar);
param[5] = new SqlParameter("@u_childno", SqlDbType.NVarChar);
param[6] = new SqlParameter("@u_khedmat", SqlDbType.NVarChar);
param[7] = new SqlParameter("@u_takafol", SqlDbType.NVarChar);
param[8] = new SqlParameter("@u_grade", SqlDbType.NVarChar);
param[9] = new SqlParameter("@u_start", SqlDbType.NVarChar);
param[10] = new SqlParameter("@u_remark", SqlDbType.NVarChar);
param[0].Value = objEmploee.UserID;
param[1].Value = objEmploee.LastCertification;
param[2].Value = objEmploee.LastCertificationDate;
param[3].Value = objEmploee.DiplomeDate;
param[4].Value = objEmploee.Taahol;
param[5].Value = objEmploee.ChildrenNo;
param[6].Value = objEmploee.Khedmat;
param[7].Value = objEmploee.Takafol;
param[8].Value = objEmploee.Organizationgrade;
param[9].Value = objEmploee.StartDate;
param[10].Value = objEmploee.Remark;
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "sp_addEmploeeDetails", param);
}
catch (Exception ex)
{
MessageBox.Show(error + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
finally
{
connection.Close();
}
}
}
public void InsertNewEmploeeLogData(EmploeeDetails objEmploee)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@u_vid", SqlDbType.NVarChar);
param[1] = new SqlParameter("@u_username", SqlDbType.NVarChar);
param[2] = new SqlParameter("@u_password", SqlDbType.NVarChar);
param[3] = new SqlParameter("@u_type", SqlDbType.NVarChar);
param[0].Value = objEmploee.UserID;
param[1].Value = objEmploee.UserLogName;
param[2].Value = objEmploee.UserLogPassword;
param[3].Value = objEmploee.IsAdmin;
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "sp_addEmploeeLogData", param);
}
catch (Exception ex)
{
MessageBox.Show(error + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
finally
{
connection.Close();
}
}
}
}
}
كه هر سه دستور Insert رو همينجا گذاشتم
BLL
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using Haser_App.DAL;
using Haser_App.DAL.Sql;
namespace Haser_App.BLL
{
public class Emploee
{
private string errorMessage = Haser_App.Properties.Resources.InsertError;
/// <summary>
/// Insert new emploee details to emploee list
/// </summary>
/// <param name="emploeeFields">Prepair emploee details list</param>
public void AddNewEmploee(EmploeeDetails emploeeFields)
{
try
{
emploeeDataAccess emploeeDAL = new emploeeDataAccess();
emploeeDAL.InsertNewEmploee(emploeeFields);
}
catch (Exception ex)
{
MessageBox.Show(errorMessage + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
}
}
/// <summary>
/// Insert new emploee details to emploee list
/// </summary>
/// <param name="emploeeFields">Prepair emploee details list</param>
public void AddNewEmploeeDetails(EmploeeDetails emploeeFields)
{
try
{
emploeeDataAccess emploeeDAL = new emploeeDataAccess();
emploeeDAL.InsertNewEmploeeDetails(emploeeFields);
}
catch (Exception ex)
{
MessageBox.Show(errorMessage + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
}
}
public void AddNewEmploeeLogData(EmploeeDetails emploeeFields)
{
try
{
emploeeDataAccess emploeeDAL = new emploeeDataAccess();
emploeeDAL.InsertNewEmploeeLogData(emploeeFields);
}
catch (Exception ex)
{
MessageBox.Show(errorMessage + "\n" + ex.Message + "\n" + ex.Source.ToString(), "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading);
}
}
}
}
متاسفانه به دليل بي تجربگي، نفهميدم كه چطور BeginTrans / Commit / Rollback رو بنويسم. اگه امكان داره يه مقدار بيشتر راهنمايي كنيد.
دوم - اصل مسئله اينه:
يه فرم براي ثبت نام كارمندها دارم.
اولين دستور اطلاعات شخصي رو وارد يه جدول مي كنه.
دومين دستور اطلاعات پرسنلي رو وارد يه جدول ديگه مي كنه.
سومين دستور اطلاعات كاربري سيستم براي همون كارمند رو وارد يه جدول ديگه مي كنه.
همه ي اين اطلاعات يا بايد وارد جداول مربوطه بشن يا هيچكدوم.