public int InsertJobCardQC(JobCardQC objJobCardQC)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction trn = connection.BeginTransaction();
try
{
int id = 0;
string internalId = DatabaseCommonRepository.GetNewDocNo(connection, objJobCardQC.OrganizationId, 17, true, trn);
objJobCardQC.JobCardQCRefNo = internalId;
string sql = @"INSERT INTO JobCardQC(JobCardId,JobCardQCRefNo,EmployeeId,JobCardQCDate,IsQCPassed,CreatedBy,CreatedDate,OrganizationId,Remarks, PunchingNo)
VALUES (@JobCardId,@JobCardQCRefNo,@EmployeeId,GETDATE(),@IsQCPassed,@CreatedBy,GETDATE(),@OrganizationId,@Remarks, @PunchingNo);
SELECT CAST(SCOPE_IDENTITY() as int)";
id = connection.Query <int>(sql, objJobCardQC, trn).Single();
var JobCardQCParamRepo = new JobCardQCParamRepository();
foreach (var item in objJobCardQC.JobCardQCParams)
{
item.JobCardQCId = id;
JobCardQCParamRepo.InsertSaleOrderItem(item, connection, trn);
}
InsertLoginHistory(dataConnection, objJobCardQC.CreatedBy, "Create", "Job Card QC", id.ToString(), "0");
trn.Commit();
return(id);
}
catch (Exception)
{
trn.Rollback();
return(0);
}
}
}
public int UpdateJobCardQC(JobCardQC objJobCardQC)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction txn = connection.BeginTransaction();
string sql = @"UPDATE
JobCardQC SET JobCardQCRefNo=@JobCardQCRefNo,EmployeeId=@EmployeeId,
JobCardQCDate=@JobCardQCDate,IsQCPassed=@IsQCPassed,CreatedBy=@CreatedBy,
CreatedDate=@CreatedDate,OrganizationId=@OrganizationId,Remarks=@Remarks,
PunchingNo = @PunchingNo
WHERE JobCardId = @JobCardId;";
try
{
var id = connection.Execute(sql, objJobCardQC, txn);
int i = 0;
var JobCardQCParamRepo = new JobCardQCParamRepository();
foreach (var item in objJobCardQC.JobCardQCParams)
{
item.JobCardQCId = objJobCardQC.JobCardQCId;
JobCardQCParamRepo.InsertSaleOrderItem(item, connection, txn);
}
InsertLoginHistory(dataConnection, objJobCardQC.CreatedBy, "Update", "Project Completion", id.ToString(), objJobCardQC.OrganizationId.ToString());
txn.Commit();
return(id);
}
catch (Exception ex)
{
txn.Rollback();
throw ex;
}
}
}
