public int Insert(ASSETKKF_MODEL.Data.Mssql.bsicpers.rmEmployee d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@EmployeeID", d.EmployeeID);
param.Add("@EmploType", d.EmploType);
param.Add("@Status", d.Status);
param.Add("@Shift", d.Shift);
param.Add("@Weekend", d.Weekend);
param.Add("@DepCode", d.DepCode);
param.Add("@Position", d.Position);
param.Add("@TitleName", d.TitleName);
param.Add("@FirstName", d.FirstName);
param.Add("@LastName", d.LastName);
param.Add("@StartDate", d.StartDate);
param.Add("@EmploDate", d.EmploDate);
param.Add("@EndDate", d.EndDate);
param.Add("@EditDate", d.EditDate);
string cmd = "INSERT INTO .dbo.rmEmployee " +
$" (EmployeeID, EmploType, Status, Shift, Weekend, DepCode, Position, TitleName, FirstName, LastName, StartDate, EmploDate, EndDate, EditDate) " +
$"VALUES(@EmployeeID, @EmploType, @Status, @Shift, @Weekend, @DepCode, @Position, @TitleName, @FirstName, @LastName, @StartDate, @EmploDate, @EndDate, @EditDate); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Update(ASSETKKF_MODEL.Data.Mssql.bsicpers.rmEmployee d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@EmployeeID", d.EmployeeID.GetValue());
param.Add("@EmploType", d.EmploType.GetValue());
param.Add("@Status", d.Status.GetValue());
param.Add("@Shift", d.Shift.GetValue());
param.Add("@Weekend", d.Weekend.GetValue());
param.Add("@DepCode", d.DepCode.GetValue());
param.Add("@Position", d.Position.GetValue());
param.Add("@TitleName", d.TitleName.GetValue());
param.Add("@FirstName", d.FirstName.GetValue());
param.Add("@LastName", d.LastName.GetValue());
param.Add("@StartDate", d.StartDate);
param.Add("@EmploDate", d.EmploDate);
param.Add("@EndDate", d.EndDate);
param.Add("@EditDate", d.EditDate);
string cmd = "";
/*
* cmd = UPDATE .dbo.rmEmployee "+
* "SET EmployeeID = @.EmployeeID "+
* " , EmploType = @.EmploType "+
* " , Status = @.Status "+
* " , Shift = @.Shift "+
* " , Weekend = @.Weekend "+
* " , DepCode = @.DepCode "+
* " , Position = @.Position "+
* " , TitleName = @.TitleName "+
* " , FirstName = @.FirstName "+
* " , LastName = @.LastName "+
* " , StartDate = @.StartDate "+
* " , EmploDate = @.EmploDate "+
* " , EndDate = @.EndDate "+
* " , EditDate = @.EditDate "+
* "WHERE EmployeeID = @.EmployeeID "+
* " AND EmploType = @.EmploType "+
* " AND Status = @.Status "+
* " AND Shift = @.Shift "+
* " AND Weekend = @.Weekend "+
* " AND DepCode = @.DepCode "+
* " AND Position = @.Position "+
* " AND TitleName = @.TitleName "+
* " AND FirstName = @.FirstName "+
* " AND LastName = @.LastName "+
* " AND StartDate = @.StartDate "+
* " AND EmploDate = @.EmploDate "+
* " AND EndDate = @.EndDate "+
* " AND EditDate = @.EditDate "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
