protected void Page_Load(object sender, EventArgs e)
{
lblProfileName.Text = " Wellcome," + " " + USERPROFILEMASTER.GetByUser_Name(Session["UserName"] == null ? string.Empty : Session["UserName"].ToString()).First_Name + " " + USERPROFILEMASTER.GetByUser_Name(Session["UserName"] == null ? string.Empty : Session["UserName"].ToString()).Last_Name;
decimal Am = USERPROFILEMASTER.GetByRegistration_ID(int.Parse(Session["loginid"].ToString())).UserWallet;
lblWallet.Text = Am.ToString();
}
public string SaveUser(SaveUserClass user)
{
try
{
string constr = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
USERPROFILEMASTER rm = new USERPROFILEMASTER();
rm.Registration_ID = USERPROFILEMASTER.MaxId() + 1;
rm.First_Name = user.Fname;
rm.Last_Name = user.Lname;
rm.Email = user.Email;
rm.User_Name = user.UserName;
rm.User_ID = "OM000000" + rm.Registration_ID;
rm.Password = user.Password;
rm.DOB = DateTime.Today;
rm.ContactNumber = user.ContactNo;
rm.NomineeName = "";
rm.NomineeId = "";
rm.NomineeRelation = "";
USERPROFILEMASTER um1 = USERPROFILEMASTER.GetByUser_Name(user.RefId);
if (string.IsNullOrWhiteSpace(um1.Reference_Id))
{
return("Reference Id is not available");
}
rm.Reference_Id = user.RefId;
rm.RegDate = DateTime.Today.Date;
rm.COUNTRY = "India";
rm.Individual_Company = ""; rm.IdentificationType = ""; rm.TaxExempt = ""; rm.Commission = ""; rm.WFile = "";
rm.AnniversaryDate = DateTime.Today; rm.SmartDeliveryDate = DateTime.Today;
rm.Website = ""; rm.Address = ""; rm.AddressLine2 = ""; rm.City = 1; rm.State = 1; rm.StateOther = "";
rm.ZipCode = ""; rm.ShippingFirstName = ""; rm.ShippingLastName = ""; rm.ShippingAddress = "";
rm.ShippingAddressLine2 = ""; rm.ShippingCity = 1; rm.ShippingState = 1; rm.ShippingZip = ""; rm.ShippingStateOther = "";
rm.AlternativeNumber = ""; rm.Fax = ""; rm.Co_Applicant = ""; rm.Language = ""; rm.Skype = ""; rm.Twitter = ""; rm.Facebook = ""; rm.AadharVerified = "";
rm.AadharImage = ""; rm.PanVerified = ""; rm.PanImage = ""; rm.ChequeVerified = ""; rm.ChequeImage = ""; rm.GstinVerified = "";
rm.AddressVerified = ""; rm.AddressImage = ""; rm.Image_Name = ""; rm.Status = "Active"; rm.BankName = ""; rm.AccountNo = "";
rm.IFSCCode = ""; rm.Branch = ""; rm.UserParentId = 0;
rm.Save();
// Sendmsg("Welcome to OMHRD " + " ", user.ContactNo.Trim());
}
return(string.Empty);
}
catch (Exception ex)
{
return("Username is not available");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["loginid"] != null && !string.IsNullOrEmpty(Session["loginid"].ToString()))
{
myAccount.Visible = true;
}
else
{
myAccount.Visible = false;
}
loggedinUserId.Value = Session["loginid"] == null ? string.Empty : Session["loginid"].ToString();
FIllAllProduct();
lblProfileName.Text = " Hello," + USERPROFILEMASTER.GetByUser_Name(Session["UserName"] == null ? string.Empty : Session["UserName"].ToString()).User_Name;
}
}
protected void btnPayment_Click(object sender, EventArgs e)
{
try
{
PaymentMaster um = new PaymentMaster();
if (btnPayment.Text == "Submit")
{
um.Paymemt_ID = PaymentMaster.GetMaxID() + 1;
um.User_Name = ddlUserName.SelectedItem.Text;
um.User_ID = USERPROFILEMASTER.GetByUser_Name(um.User_Name).User_Name;// lblUSerId.Text.Trim();
um.Amount = decimal.Parse(txtamount.Text);
um.Remark = txtremark.Text.Trim();
um.Save();
grid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Submit Successfully....');</Script>", false);
}
else if (btnPayment.Text == "Update")
{
um = PaymentMaster.GetByPaymemt_ID(int.Parse(ViewState["id"].ToString()));
um.Paymemt_ID = int.Parse(ViewState["id"].ToString());
um.User_Name = ddlUserName.SelectedItem.Text;
um.User_ID = USERPROFILEMASTER.GetByUser_Name(um.User_Name).User_Name;// lblUSerId.Text.Trim();
um.Amount = decimal.Parse(txtamount.Text);
um.Remark = txtremark.Text.Trim();
um.Save();
btnPayment.Text = "Submit";
grid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Update Successfully..');</Script>", false);
}
ClearInputs(Page.Controls);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert(error);</script>", false);
}
}
public void PrintBill()
{
try
{
int UserId = 0;
Int32.TryParse(ddlUser.SelectedValue, out UserId);
List <ProductInvoice_Master> _Pro = ProductInvoice_MasterCollection.GetAll().FindAll(x => x.BILL_ID == billid);
#region Company
string CompanyName = USERPROFILEMASTER.GetByUser_Name("OMHRD").First_Name;
string CompanyAddress = USERPROFILEMASTER.GetByUser_Name("OMHRD").Address;
string CompanyState = USERPROFILEMASTER.GetByUser_Name("OMHRD").StateName;
string CompanyCity = USERPROFILEMASTER.GetByUser_Name("OMHRD").CityName;
string ZipCode = USERPROFILEMASTER.GetByUser_Name("OMHRD").ZipCode;
string CompanyGST = USERPROFILEMASTER.GetByUser_Name("OMHRD").GstinVerified;
string CompanyContact = USERPROFILEMASTER.GetByUser_Name("OMHRD").ContactNumber;
#endregion
#region Seller
string ShipName = USERPROFILEMASTER.GetByRegistration_ID(UserId).First_Name + " " + USERPROFILEMASTER.GetByRegistration_ID(UserId).Last_Name;
string ShipAdd1 = USERPROFILEMASTER.GetByRegistration_ID(UserId).Address;
string ShipAdd2 = USERPROFILEMASTER.GetByRegistration_ID(UserId).AddressLine2;
string ShipState = USERPROFILEMASTER.GetByRegistration_ID(UserId).StateName;
string ShipCity = USERPROFILEMASTER.GetByRegistration_ID(UserId).CityName;
string ShipZip = USERPROFILEMASTER.GetByRegistration_ID(UserId).ZipCode;
string Contry = USERPROFILEMASTER.GetByRegistration_ID(UserId).COUNTRY;
string BillName = USERPROFILEMASTER.GetByRegistration_ID(UserId).First_Name + " " + USERPROFILEMASTER.GetByRegistration_ID(UserId).Last_Name;
string PermanentAdd1 = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingAddress;
string PermanentAdd2 = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingAddressLine2;
string PermanentState = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippStateName;
string PermanentCity = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShipCityName;
string PermanentZip = USERPROFILEMASTER.GetByRegistration_ID(UserId).ShippingZip;
string Gstin = USERPROFILEMASTER.GetByRegistration_ID(UserId).GstinVerified;
#endregion
#region PickUp
int PicupId = int.Parse(Session["PickupID"].ToString());
string PickUpName = PickupMaster.GetByPickupID(PicupId).FirstName + " " + PickupMaster.GetByPickupID(PicupId).LastName;
string PickUpAddress = PickupMaster.GetByPickupID(PicupId).Address;
string PickUpContact = PickupMaster.GetByPickupID(PicupId).ContactNo;
string CenterName = PickupMaster.GetByPickupID(PicupId).CenterName;
string CenterCode = PickupMaster.GetByPickupID(PicupId).CenterCode;
#endregion
#region BillDetail
System.Guid guid = System.Guid.NewGuid();
String id = guid.ToString();
string OrderId = id;
DateTime dt = System.DateTime.Today;
string InvoiNo = ProductBill_Master.GetByBILL_ID(billid).BILLNO;
string InvoiDate = dt.ToString();
string Phone = USERPROFILEMASTER.GetByRegistration_ID(UserId).ContactNumber;
string Email = USERPROFILEMASTER.GetByRegistration_ID(UserId).Email;
#endregion
decimal totamt = Math.Round(ProductBill_Master.GetByBILL_ID(billid).TOTAL, 0);
var values = totamt.ToString(CultureInfo.InvariantCulture).Split('.');
Int64 rup = Convert.ToInt64(values[0]);
Int64 paise = 0;
if (values.Length == 2)
{
paise = Convert.ToInt64(values[1]);
}
string rupee = string.Empty;
string pa = string.Empty;
if (paise != 0)
{
pa = Rupees(paise) + "Paise Only";
rupee = Rupees(rup) + "Rupees and " + pa;
}
else
{
rupee = Rupees(rup) + "Rupees Only";
}
ReportViewer1.ProcessingMode = ProcessingMode.Local;
this.ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("/Report/PickUpSale.rdlc");
ReportDataSource datasource = new ReportDataSource("BillGenrate", _Pro);
ReportParameter[] rpt = new ReportParameter[33];
rpt[0] = new ReportParameter("CompanyName", CompanyName);
rpt[1] = new ReportParameter("CompanyAddress", CompanyAddress);
rpt[2] = new ReportParameter("CompanyState", CompanyState);
rpt[3] = new ReportParameter("CompanyCity", CompanyCity);
rpt[4] = new ReportParameter("ZipCode", ZipCode);
rpt[5] = new ReportParameter("CompanyGST", CompanyGST);
rpt[6] = new ReportParameter("CompanyContact", CompanyContact);
rpt[7] = new ReportParameter("ShipName", ShipName);
rpt[8] = new ReportParameter("ShipAdd1", ShipAdd1);
rpt[9] = new ReportParameter("ShipAdd2", ShipAdd2);
rpt[10] = new ReportParameter("ShipCity", ShipCity);
rpt[11] = new ReportParameter("ShipState", ShipState);
rpt[12] = new ReportParameter("ShipZip", ShipZip);
rpt[13] = new ReportParameter("Contry", Contry);
rpt[14] = new ReportParameter("BillName", BillName);
rpt[15] = new ReportParameter("PermanentAdd1", PermanentAdd1);
rpt[16] = new ReportParameter("PermanentAdd2", PermanentAdd2);
rpt[17] = new ReportParameter("PermanentCity", PermanentCity);
rpt[18] = new ReportParameter("PermanentState", PermanentState);
rpt[19] = new ReportParameter("PermanentZip", PermanentZip);
rpt[20] = new ReportParameter("Gstin", Gstin);
rpt[21] = new ReportParameter("OrderId", OrderId);
rpt[22] = new ReportParameter("InvoiNo", InvoiNo);
rpt[23] = new ReportParameter("InvoiDate", InvoiDate);
rpt[24] = new ReportParameter("Phone", Phone);
rpt[25] = new ReportParameter("Email", Email);
rpt[26] = new ReportParameter("TotalAmountWord", rupee);
rpt[27] = new ReportParameter("PaymentMod", PaymentMod);
rpt[28] = new ReportParameter("PickUpName", PickUpName);
rpt[29] = new ReportParameter("PickUpAddress", PickUpAddress);
rpt[30] = new ReportParameter("PickUpContact", PickUpContact);
rpt[31] = new ReportParameter("CenterName", CenterName);
rpt[32] = new ReportParameter("CenterCode", CenterCode);
this.ReportViewer1.LocalReport.SetParameters(rpt);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(datasource);
this.ReportViewer1.LocalReport.Refresh();
}
catch (Exception ex)
{ }
}
protected void lnkWallet2_Click(object sender, EventArgs e)
{
int UserID = int.Parse(Session["loginid"].ToString());
USERPROFILEMASTER User = USERPROFILEMASTER.GetByRegistration_ID(UserID);
if (User.Registration_ID > 0)
{
decimal UserAmount = User.UserWallet;
decimal TransferAmount = 5000;// totalAmount;
if (UserAmount <= TransferAmount)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Insufulset amount in User account.!!!')</script>", false);
return;
}
#region
SqlConnection cn = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("usp_SaveUserOrder", cn);
SqlDataAdapter adptr = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@User_id", UserID);
cn.Open();
adptr.Fill(ds);
cn.Close();
orderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString();
totalAmount = Convert.ToDecimal(ds.Tables[0].Rows[0]["TotalAmount"]);
#endregion
USERPROFILEMASTER lm = USERPROFILEMASTER.GetByUser_Name("OMHRD");
if (lm.Registration_ID > 0)
{
USERPROFILEMASTER lmm = new USERPROFILEMASTER();
decimal PreviousAmount = lm.UserWallet;
decimal Amount = totalAmount;
decimal TotalAmount = PreviousAmount + Amount;
lmm.WalletRecharge(lm.Registration_ID, TotalAmount);
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Payment successful..!!!')</script>", false);
}
}
decimal MyAmount = User.UserWallet;
decimal TranferAmount = totalAmount;
decimal FinalAmount = MyAmount - TranferAmount;
User.WalletRecharge(User.Registration_ID, FinalAmount);
#region SaveUserOrderPayment
using (SqlConnection conn = new SqlConnection(constr))
{
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand("Insert Into UserOrderPaymenttbl (Orderid, TrackingId, BankRefNo, OrderStatus,FailureMessage,PaymentMod,CardName,StatusCode,StatusMessage,ResponseCode,PaymentDate,Amount,UserId) Values (@Orderid, @TrackingId, @BankRefNo, @OrderStatus,@FailureMessage,@PaymentMod,@CardName,@StatusCode,@StatusMessage,@ResponseCode,@PaymentDate,@Amount,@UserId)", conn);
da.InsertCommand.Parameters.Add("@Orderid", SqlDbType.Int).Value = 0;
da.InsertCommand.Parameters.Add("@TrackingId", SqlDbType.Text).Value = "";
da.InsertCommand.Parameters.Add("@BankRefNo", SqlDbType.Text).Value = "";
da.InsertCommand.Parameters.Add("@OrderStatus", SqlDbType.Text).Value = "Success";
da.InsertCommand.Parameters.Add("@FailureMessage", SqlDbType.Text).Value = "";
da.InsertCommand.Parameters.Add("@PaymentMod", SqlDbType.Text).Value = "Wallet";
da.InsertCommand.Parameters.Add("@CardName", SqlDbType.Text).Value = "";
da.InsertCommand.Parameters.Add("@StatusCode", SqlDbType.Int).Value = 0;
da.InsertCommand.Parameters.Add("@StatusMessage", SqlDbType.Text).Value = "";
da.InsertCommand.Parameters.Add("@ResponseCode", SqlDbType.Int).Value = 0;
da.InsertCommand.Parameters.Add("@PaymentDate", SqlDbType.DateTime).Value = System.DateTime.Now;
da.InsertCommand.Parameters.Add("@Amount", SqlDbType.Decimal).Value = totalAmount;
da.InsertCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = UserID;
conn.Open();
da.InsertCommand.ExecuteNonQuery();
conn.Close();
}
#endregion
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Some technical error...!!!')</script>", false);
}
}