public ActionResult Edit_data_subcribe(Hosting_Subscription HS) { try { DataSet ds = _objwl.Edit_data_subcribe(HS); List<Hosting_Subscription> hosting = new List<Hosting_Subscription>(); if (ds.Tables[1].Rows.Count > 0) { ViewBag.fname = ds.Tables[1]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { hosting.Add(new Hosting_Subscription { srno = dr["srno"].ToString(), Corporate = dr["Corporate"].ToString(), PlanName = dr["PlanName"].ToString(), SubscriptionType = dr["SubscriptionType"].ToString(), FreeFlag = dr["FreeFlag"].ToString(), NumberOfUsers = dr["NumberOfUsers"].ToString(), SubscriptionFromDate = dr["SubscriptionFromDate"].ToString(), SubscriptionToDate = dr["SubscriptionToDate"].ToString(), BillingCycle = dr["BillingCycle"].ToString(), BillingFromCompany = dr["BillingFromCompany"].ToString(), PaymentCurrency = dr["PaymentCurrency"].ToString(), AmountPUPM = dr["AmountPUPM"].ToString(), PaymentMode = dr["PaymentMode"].ToString(), FirstPayDate = dr["FirstPayDate"].ToString(), GracePeriod = dr["GracePeriod"].ToString() }); } } var result = hosting; return Json(new { Whiteregjs = result }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_data_hosting(Hosting_Subscription HS) { try { DataSet ds = _objwl.Edit_data_hosting(HS); List<Hosting_Subscription> hosting = new List<Hosting_Subscription>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { hosting.Add(new Hosting_Subscription { srno = dr["srno"].ToString(), Corporate = dr["Corporate"].ToString(), CloudProvider = dr["CloudProvider"].ToString(), CloudServerIp = dr["CloudServerIp"].ToString(), CloudDiskSpace = dr["CloudDiskSpace"].ToString(), TransactionCount = dr["TransactionCount"].ToString(), IpRestrictedAccess = dr["IpRestrictedAccess"].ToString(), CdnProvider = dr["CdnProvider"].ToString(), CdnSpace = dr["CdnSpace"].ToString(), HostingCost = dr["HostingCost"].ToString(), CostPerMonth = dr["CostPerMonth"].ToString(), Currency = dr["Currency"].ToString(), HostingCostPM = dr["HostingCostPM"].ToString() }); } } var result = hosting; return Json(new { Whiteregjs = result }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult insert_Hosting(Hosting_Subscription HS) { try { DataSet ds = _objwl.insert_Hosting(HS); DataSet ds2 = _objwl.insert_Hosting_sub(HS); if (ds.Tables[0].Rows.Count > 0) { ViewBag.srno = ds.Tables[0].Rows[0]["Srno"]; ViewBag.Message = ds.Tables[0].Rows[0]["msg"]; if (ds.Tables[0].Rows[0]["Help"].ToString() == "Save" || ds.Tables[0].Rows[0]["Help"].ToString() == "Update") { ViewBag.Event = "success"; } else if (ds.Tables[0].Rows[0]["Help"].ToString() == "Duplicate") { ViewBag.Event = "error"; } } return Json(new { srno = ViewBag.srno, Event = ViewBag.Event, responseText = ViewBag.Message }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public DataSet Edit_data_subcribe(Hosting_Subscription HS) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Edit_White_Register_Hosting_Subscription", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@tablename", "dbo._White_Register_Hosting"); _cmd.Parameters.AddWithValue("@Corporate", HS.Corporate); _cmd.Parameters.AddWithValue("@unit", "0"); _cmd.Parameters.AddWithValue("@Formcode", "0"); _cmd.Parameters.AddWithValue("@Formtabcode", "0"); _cmd.Parameters.AddWithValue("@srno", HS.srno); //_cmd.Parameters.AddWithValue("@srno","0"); _cmd.Parameters.AddWithValue("@Type", "EditMode"); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return _ds; } catch (Exception) { throw; } finally { _cn.Close(); _cn.Dispose(); } }
public DataSet insert_Hosting_sub(Hosting_Subscription HS) { try { using (SqlConnection sconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["gtcon"].ConnectionString)) { sconn.Open(); using (SqlCommand _cmd = new SqlCommand("sp_save_White_Register_Subscription", sconn)) { // _cn.Open(); // SqlCommand _cmd = new SqlCommand("sp_save_White_Register_Subscription", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@srno", HS.srno); _cmd.Parameters.AddWithValue("@Corporate", HS.Corporate); _cmd.Parameters.AddWithValue("@PlanName", HS.PlanName); _cmd.Parameters.AddWithValue("@SubscriptionType", HS.SubscriptionType); _cmd.Parameters.AddWithValue("@FreeFlag", HS.FreeFlag); _cmd.Parameters.AddWithValue("@NumberOfUsers", HS.NumberOfUsers); _cmd.Parameters.AddWithValue("@BillingCycle", HS.BillingCycle); _cmd.Parameters.AddWithValue("@BillingFromCompany", HS.BillingFromCompany); _cmd.Parameters.AddWithValue("@PaymentCurrency", HS.PaymentCurrency); _cmd.Parameters.AddWithValue("@AmountPUPM", HS.AmountPUPM); _cmd.Parameters.AddWithValue("@PaymentMode", HS.PaymentMode); _cmd.Parameters.AddWithValue("@GracePeriod", HS.GracePeriod); if (HS.SubscriptionFromDate == null) { _cmd.Parameters.AddWithValue("@SubscriptionFromDate", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@SubscriptionFromDate", DateTime.ParseExact(HS.SubscriptionFromDate, "dd/MM/yyyy", null)); } if (HS.SubscriptionToDate == null) { _cmd.Parameters.AddWithValue("@SubscriptionToDate", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@SubscriptionToDate", DateTime.ParseExact(HS.SubscriptionToDate, "dd/MM/yyyy", null)); } if (HS.FirstPayDate == null) { _cmd.Parameters.AddWithValue("@FirstPayDate", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@FirstPayDate", DateTime.ParseExact(HS.FirstPayDate, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@Attribute1", HS.Attribute1); _cmd.Parameters.AddWithValue("@Attribute2", HS.Attribute2); _cmd.Parameters.AddWithValue("@Attribute3", HS.Attribute3); _cmd.Parameters.AddWithValue("@Attribute4", HS.Attribute4); _cmd.Parameters.AddWithValue("@Attribute5", HS.Attribute5); _cmd.Parameters.AddWithValue("@Attribute6", HS.Attribute6); _cmd.Parameters.AddWithValue("@Attribute7", HS.Attribute7); _cmd.Parameters.AddWithValue("@Attribute8", HS.Attribute8); _cmd.Parameters.AddWithValue("@Attribute9", HS.Attribute9); _cmd.Parameters.AddWithValue("@Attribute10", HS.Attribute10); _cmd.Parameters.AddWithValue("@CreatedBy", HS.CreatedBy); _cmd.Parameters.AddWithValue("@CorpcentreBy", HS.CorpcentreBy); _cmd.Parameters.AddWithValue("@UnitCorpBy", HS.UnitCorpBy); _cmd.Parameters.AddWithValue("@TerminalBy", HS.TerminalBy); _cmd.Parameters.AddWithValue("@BranchBy", HS.BranchBy); SqlDataAdapter adp = new SqlDataAdapter(_cmd); DataSet ds = new DataSet(); adp.Fill(ds); adp.Dispose(); _cmd.Dispose(); sconn.Close(); sconn.Dispose(); return ds; } } } catch { throw; } finally { //_cn.Close(); // _cn.Dispose(); } }
public DataSet insert_Hosting(Hosting_Subscription HS) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_save_White_Register_Hosting", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@srno", HS.srno); _cmd.Parameters.AddWithValue("@Corporate", HS.Corporate); _cmd.Parameters.AddWithValue("@CloudProvider", HS.CloudProvider); _cmd.Parameters.AddWithValue("@CloudServerIp", HS.CloudServerIp); _cmd.Parameters.AddWithValue("@CloudDiskSpace", HS.CloudDiskSpace); _cmd.Parameters.AddWithValue("@TransactionCount", HS.TransactionCount); _cmd.Parameters.AddWithValue("@IpRestrictedAccess", HS.IpRestrictedAccess); _cmd.Parameters.AddWithValue("@CdnProvider", HS.CdnProvider); _cmd.Parameters.AddWithValue("@CdnSpace", HS.CdnSpace); _cmd.Parameters.AddWithValue("@HostingCost", HS.HostingCost); _cmd.Parameters.AddWithValue("@CostPerMonth", HS.CostPerMonth); _cmd.Parameters.AddWithValue("@Currency", HS.Currency); _cmd.Parameters.AddWithValue("@Attribute1", HS.Attribute1); _cmd.Parameters.AddWithValue("@Attribute2", HS.Attribute2); _cmd.Parameters.AddWithValue("@Attribute3", HS.Attribute3); _cmd.Parameters.AddWithValue("@Attribute4", HS.Attribute4); _cmd.Parameters.AddWithValue("@Attribute5", HS.Attribute5); _cmd.Parameters.AddWithValue("@Attribute6", HS.Attribute6); _cmd.Parameters.AddWithValue("@Attribute7", HS.Attribute7); _cmd.Parameters.AddWithValue("@Attribute8", HS.Attribute8); _cmd.Parameters.AddWithValue("@Attribute9", HS.Attribute9); _cmd.Parameters.AddWithValue("@Attribute10", HS.Attribute10); _cmd.Parameters.AddWithValue("@HostingCostPM", HS.HostingCostPM); _cmd.Parameters.AddWithValue("@CreatedBy", HS.CreatedBy); _cmd.Parameters.AddWithValue("@CorpcentreBy", HS.CorpcentreBy); _cmd.Parameters.AddWithValue("@UnitCorpBy", HS.UnitCorpBy); _cmd.Parameters.AddWithValue("@TerminalBy", HS.TerminalBy); _cmd.Parameters.AddWithValue("@BranchBy", HS.BranchBy); SqlDataAdapter adp = new SqlDataAdapter(_cmd); DataSet ds = new DataSet(); adp.Fill(ds); adp.Dispose(); _cmd.Dispose(); return ds; } catch { throw; } finally { _cn.Close(); _cn.Dispose(); } }