public bool Create(TB_BusinessPartnerCancelPolicyExt model, ref string Msg, Controller ctrl) { bool status = true; TB_BusinessPartnerCancelPolicy obj = new TB_BusinessPartnerCancelPolicy(); // obj.ID = model.ID; obj.BusinessPartnerID = model.BusinessPartnerID; obj.PartID = model.PartID; obj.CancelTypeID = model.CancelTypeID; obj.RefundableDayCount = model.RefundableDayCount; if (model.PenaultyRateID != 0) { obj.PenaltyRateTypeID = model.PenaultyRateID; } else { obj.PenaltyRateTypeID = null; } obj.Active = model.Active; obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.TB_BusinessPartnerCancelPolicy.Add(obj); db.SaveChanges(); int id = Convert.ToInt32(obj.ID); return status; }
public List<TB_BusinessPartnerCancelPolicyExt> ReadAll(int TableID) { List<TB_BusinessPartnerCancelPolicyExt> list = new List<TB_BusinessPartnerCancelPolicyExt>(); DataTable dt = new DataTable(); SQLCon.Open(); SqlCommand cmd = new SqlCommand("B_DisplayTableNew_BizTbl_Table_Sp", SQLCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TableID", TableID); cmd.Parameters.AddWithValue("@CultureCode", CultureCode); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); SQLCon.Close(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TB_BusinessPartnerCancelPolicyExt model = new TB_BusinessPartnerCancelPolicyExt(); model.ID = Convert.ToInt32(dr["ID"]); model.BusinessPartnerID = Convert.ToInt32(dr["BusinessPartnerID"]); model.BusinessPartner = dr["FK_BusinessPartnerID_ID"].ToString(); model.PartID = Convert.ToInt32(dr["PartID"]); model.Part = dr["FK_PartID_ID"].ToString(); model.CancelTypeID = Convert.ToInt32(dr["CancelTypeID"]); model.CancelType = dr["FK_CancelTypeID_ID"].ToString(); model.RefundableDayCount = Convert.ToInt32(dr["RefundableDayCount"]); if (dr["PenaltyRateTypeID"].ToString() != null && dr["PenaltyRateTypeID"].ToString() != "") { model.PenaultyRateID = Convert.ToInt32(dr["PenaltyRateTypeID"]); } else { model.PenaultyRateID = 0; } model.PenaultyRate = dr["FK_PenaltyRateTypeID_ID"].ToString(); model.Active = Convert.ToBoolean(dr["Active"]); list.Add(model); } } return list; }
public bool Update(TB_BusinessPartnerCancelPolicyExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_BusinessPartnerCancelPolicy.Where(x => x.ID == model.ID).FirstOrDefault(); obj.ID = model.ID; obj.BusinessPartnerID = Convert.ToInt32(model.BusinessPartnerID); obj.PartID = Convert.ToInt32(model.PartID); obj.CancelTypeID = Convert.ToInt32(model.CancelTypeID); obj.RefundableDayCount = model.RefundableDayCount; // obj.PenaltyRateTypeID = Convert.ToInt32(model.PenaltyRateID); if (model.PenaultyRateID != 0) { obj.PenaltyRateTypeID = model.PenaultyRateID; } else { obj.PenaltyRateTypeID = null; } obj.Active = model.Active; obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.SaveChanges(); return status; }
public bool Delete(TB_BusinessPartnerCancelPolicyExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_BusinessPartnerCancelPolicy.Where(x => x.ID == model.ID).FirstOrDefault(); db.TB_BusinessPartnerCancelPolicy.Remove(obj); db.SaveChanges(); return status; }