public void UpdateEmployeeWithAttachment(EmployeeEntity entity, EmployeeAttachmentEntityNewLogic[] employeeAttachmentEntityNewLogics)
{
base.UseTran((tran) =>
{
var cmd = GetUpdateEmployeeCommand(this.Database, entity);
base.Database.ExecuteNonQuery(cmd, tran);
base.DeleteRelationData("employeeattachment", entity.EmpId, tran);
employeeAttachmentEntityNewLogics.ToList().ForEach((attach) =>
{
var cmd1 = GetCreateAttachmentCommand(this.Database, attach);
base.Database.ExecuteNonQuery(cmd1, tran);
var attachId = base.Database.GetParameterValue(cmd1, "Id").ToString();
});
});
}
public static DbCommand GetCreateAttachmentCommand(Database database, EmployeeAttachmentEntityNewLogic attach)
{
DbCommand cmd = database.GetStoredProcCommand("P_CreateEmployeeAttachment");
database.AddOutParameter(cmd, "Id", DbType.String, 36);
database.AddInParameter(cmd, "EmpId", DbType.String, attach.EmpId);
database.AddInParameter(cmd, "SaveName", DbType.String, attach.SaveName);
database.AddInParameter(cmd, "ShowName", DbType.String, attach.ShowName);
return cmd;
}