public bool ChangeDiarySave(ChangeDiary obj) { bool retVal = true; string procName = (obj.Id == 0 ? "dbo.OXO_ChangeDiary_New" : "dbo.OXO_ChangeDiary_Edit"); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_OXO_Doc_Id", obj.OXODocId, dbType: DbType.Int32); para.Add("@p_Programme_Id", obj.ProgrammeId, dbType: DbType.Int32); para.Add("@p_Version_Info", obj.VersionInfo, dbType: DbType.String, size: 500); para.Add("@p_Entry_Header", obj.EntryHeader, dbType: DbType.String, size: -1); para.Add("@p_Entry_Date", obj.EntryDate, dbType: DbType.DateTime); para.Add("@p_Markets", obj.Markets, dbType: DbType.String, size: -1); para.Add("@p_Models", obj.Models, dbType: DbType.String, size: -1); para.Add("@p_Features", obj.Features, dbType: DbType.String, size: -1); para.Add("@p_Current_Fitment", obj.CurrentFitment, dbType: DbType.String, size: 50); para.Add("@p_Proposed_Fitment", obj.ProposedFitment, dbType: DbType.String, size: 50); para.Add("@p_Comment", obj.Comment, dbType: DbType.String, size: -1); para.Add("@p_Pricing_Status", obj.PricingStatus, dbType: DbType.String, size: 500); para.Add("@p_Digital_Status", obj.DigitalStatus, dbType: DbType.String, size: 500); para.Add("@p_Requester", obj.Requester, dbType: DbType.String, size: 100); para.Add("@p_PACN", obj.PACN, dbType: DbType.String, size: 100); para.Add("@p_ETracker", obj.ETracker, dbType: DbType.String, size: 100); para.Add("@p_Order_Call", obj.OrderCall, dbType: DbType.String, size: 100); para.Add("@p_Build_Effective_Date", obj.BuildEffectiveDate, dbType: DbType.DateTime); if (obj.Id == 0) { para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { para.Add("@p_Id", obj.Id, dbType: DbType.Int32); } conn.Execute(procName, para, commandType: CommandType.StoredProcedure); if (obj.Id == 0) { obj.Id = para.Get <int>("@p_Id"); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public ChangeDiary ChangeDiaryGet(int id) { ChangeDiary retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_Id", id, dbType: DbType.Int32); retVal = conn.Query <ChangeDiary>("dbo.OXO_ChangeDiary_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }