public string SaveUpdateUtilityBilling(UtilityBillingModel model) { string result = string.Empty; ShomaRMEntities db = new ShomaRMEntities(); if (model.UBID == 0) { var saveWorkorder = new tbl_UtilityBilling() { UtilityID = model.UtilityID, LeaseID = model.LeaseID, Revision_Num = model.Revision_Num, Unit = model.Unit, ChargeType = model.ChargeType, EffectiveDate = model.EffectiveDate, MeterReading = model.MeterReading, PricePerUnit = model.PricePerUnit, Posted = model.Posted, TenantID = ShomaGroupWebSession.CurrentUser.TenantID, }; db.tbl_UtilityBilling.Add(saveWorkorder); db.SaveChanges(); result = "Utility Billing Saved Successfully"; } else { var getUBDta = db.tbl_UtilityBilling.Where(p => p.UBID == model.UBID).FirstOrDefault(); if (getUBDta != null) { getUBDta.UtilityID = model.UtilityID; getUBDta.LeaseID = model.LeaseID; getUBDta.Revision_Num = model.Revision_Num; getUBDta.Unit = model.Unit; getUBDta.ChargeType = model.ChargeType; getUBDta.EffectiveDate = model.EffectiveDate; getUBDta.MeterReading = model.MeterReading; getUBDta.PricePerUnit = model.PricePerUnit; getUBDta.Posted = model.Posted; getUBDta.TenantID = model.TenantID; } db.SaveChanges(); result = "Utility Billing Updated Successfully"; } db.Dispose(); return(result); }
public UtilityBillingModel GetUBData(int id) { ShomaRMEntities db = new ShomaRMEntities(); UtilityBillingModel model = new UtilityBillingModel(); var getUBDta = db.tbl_UtilityBilling.Where(p => p.UBID == id).FirstOrDefault(); if (getUBDta != null) { model.UtilityID = getUBDta.UtilityID; model.LeaseID = getUBDta.LeaseID; model.Revision_Num = getUBDta.Revision_Num; model.Unit = getUBDta.Unit; model.ChargeType = getUBDta.ChargeType; model.EffectiveDate = getUBDta.EffectiveDate; model.MeterReading = getUBDta.MeterReading; model.PricePerUnit = getUBDta.PricePerUnit; model.Posted = getUBDta.Posted; model.TenantID = getUBDta.TenantID; } model.UBID = id; return(model); }
public List <UtilityBillingModel> GetUtilityBillingList(DateTime FromDate, DateTime ToDate) { ShomaRMEntities db = new ShomaRMEntities(); List <UtilityBillingModel> lstpr = new List <UtilityBillingModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetUtilityBillingList"; cmd.CommandType = CommandType.StoredProcedure; DbParameter paramF = cmd.CreateParameter(); paramF.ParameterName = "FromDate"; paramF.Value = FromDate; cmd.Parameters.Add(paramF); DbParameter paramC = cmd.CreateParameter(); paramC.ParameterName = "ToDate"; paramC.Value = ToDate; cmd.Parameters.Add(paramC); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { UtilityBillingModel pr = new UtilityBillingModel(); DateTime?effectiveDate = null; try { effectiveDate = Convert.ToDateTime(dr["EffectiveDate"].ToString()); } catch { } pr.UBID = Convert.ToInt32(dr["UBID"].ToString()); pr.UtilityTitle = dr["UtilityTitle"].ToString(); pr.UtilityID = Convert.ToInt32(dr["UtilityID"].ToString()); pr.LeaseID = Convert.ToInt32(dr["LeaseID"].ToString()); pr.Revision_Num = Convert.ToInt32(dr["Revision_Num"].ToString()); pr.Unit = dr["Unit"].ToString(); pr.ChargeType = dr["ChargeType"].ToString(); pr.EffectiveDateString = effectiveDate == null ? "" : effectiveDate.Value.ToString("MM/dd/yyy"); pr.MeterReading = Convert.ToDecimal(dr["MeterReading"].ToString()); pr.PricePerUnit = Convert.ToDecimal(dr["PricePerUnit"].ToString()); pr.Posted = Convert.ToDateTime(dr["Posted"].ToString()); pr.TenantID = Convert.ToInt64(dr["TenantID"].ToString()); lstpr.Add(pr); } db.Dispose(); return(lstpr.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }