protected void btnsave_Click(object sender, EventArgs e) { try { if (Request.QueryString.AllKeys.Contains("ID")) { if (!Request.QueryString["ID"].ToString().Equals("")) { if (txtname.Text.Trim() != "" && txturl.Text.Trim() != "") { string[] ins = { txtname.Text.Trim(), txturl.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("update Pages set Name=@1,PageUrl=@2 where id=" + Request.QueryString["ID"].ToString() + "", ins); if (i > 0) { Response.Redirect("~/RoleManagement/AddPages.aspx", false); } } else { getdata(); ltrerr.Text = "Please fill all details"; } } } else { if (txtname.Text.Trim() != "" && txturl.Text.Trim() != "") { string[] ins = { txtname.Text.Trim(), txturl.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("insert into Pages (Name,PageUrl,doc) values(@1,@2,Dateadd(Minute,330,Getutcdate()))", ins); if (i > 0) { getdata(); ltrerr.Text = "Inserted Successfully"; txtname.Text = ""; txturl.Text = ""; } else { getdata(); ltrerr.Text = "Not Inserted"; } } else { getdata(); ltrerr.Text = "Please fill all details"; } } } catch (Exception ex) { ltrerr.Text = ex.Message; } }
protected void cmdSave_Click(object sender, EventArgs e) { try { if (Request.QueryString.AllKeys.Contains("ID")) { if (!Request.QueryString["ID"].ToString().Equals("")) { if (txtrole.Text.Trim() != "") { string[] ins = { txtrole.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("update Role set RoleName=@1 where id=" + Request.QueryString["ID"].ToString() + "", ins); if (i > 0) { Response.Redirect("~/RoleManagement/Role.aspx", false); } } else { getdata(); ltrErr.Text = "Please fill all details"; } } } else { if (txtrole.Text.Trim() != "") { string[] ins = { txtrole.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("insert into Role (RoleName) values(@1)", ins); if (i > 0) { getdata(); ltrErr.Text = "Inserted Successfully"; txtrole.Text = ""; } else { getdata(); ltrErr.Text = "Not Inserted"; } } else { getdata(); ltrErr.Text = "Please fill all details"; } } } catch (Exception ex) { ltrErr.Text = ex.Message; } }
public static void InsertLogs(InvoiceLOGS.InvoiceLogLevel Logtype, string tranid = "", int paymentmethod = 0, bool issuccess = false, String ShortMsg = "", String detailmsg = "") { dbConnection dbc = new dbConnection(); try { DateTime curr_time = dbc.getindiantime(); int logtypeid = 0; logtypeid = (int)Logtype; if (InvoiceLOGS.InvoiceLogLevel.Success.CompareTo(Logtype) == 1) { //logtypeid = InvoiceLOGS.InvoiceLogLevel.Success; } //InvoiceLOGS.InvoiceLogLevel.TryParse(Logtype.ToString(), out logtypeid); //InvoiceLOGS.InvoiceLogLevel myval = (InvoiceLOGS.InvoiceLogLevel)Enum.Parse(typeof(TestEnum), Logtype.ToString()); string[] insert = { logtypeid.ToString(), tranid, paymentmethod.ToString(), issuccess.ToString(), detailmsg, ShortMsg }; string cmd = "INSERT INTO [dbo].[PaymentTransactionLogs] ([LogLevel],[TrnId],[PaymentMethod],[IsSuccess],[ResponseString],[DOC],[ShortMsg]) VALUES (@1,@2,@3,@4,@5,DATEADD(MINUTE, 330, GETUTCDATE()),@6)"; int value = dbc.ExecuteQueryWithParams(cmd, insert); } catch (Exception ex) { } finally { dbc.closeConnection(); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); DateTime dt = DateTime.Now; string[] para1 = { txtContact.Text.ToString().Replace("'", "''"), txtEmailId.Text.ToString().Replace("'", "''"), txtComments.Text.ToString().Replace("'", "''"), dt.ToString(), userId }; id = Request.QueryString["Id"]; if (id != null && !id.Equals("")) { string queryupdate = "UPDATE [JurisdictionMaster] SET [Contact]=@1,[EmalID]=@2,[Comments]=@3,[ModifiedOn]=@4,[ModifiedBy]=@5 Where JurisdictionID = " + id; int v1 = dbc.ExecuteQueryWithParams(queryupdate, para1); if (v1 > 0) { sweetMessage("", "Juurisdiction Updated Successfully", "success"); Response.Redirect("Jurisdiction.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
public int InsertIsOffer(int bid, string img, string msg) { try { dbConnection dbc = new dbConnection(); int display = 0; if (img.Trim().Equals("")) { display = 0; } else { display = 1; } string[] ins = { img.Trim(), display.ToString(), msg.Trim(), bid.ToString() }; int i = dbc.ExecuteQueryWithParams("insert into Taaza_Offer_Notification (Imageurl,ImageDisplay,OfferStatus,OfferMessage,StartDate,Notification_Id) Values (@1,@2,1,@3,DATEADD(MINUTE, 330, GETUTCDATE()),@4 )", ins); if (i > 0) { return(1); } else { return(0); } } catch (Exception ex) { return(0); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); string categoryId = ddlCategoryName.SelectedValue.ToString(); int IsActive = 0; if (chkisactive.Checked) { IsActive = 1; } DateTime dt = DateTime.Now; if (BtnSave.Text.Equals("Update")) { string id = Request.QueryString["id"].ToString(); string[] para1 = { txtSubCategoryName.Text, txtDescription.Text, IsActive.ToString(), dt.ToString(), userId, id, txtSequence.Text, categoryId }; string query = "UPDATE [tblSubCategory] SET [SubCategory]=@1,[Description]=@2,[IsActive]=@3,[ModifiedOn]=@4,[ModifiedBy]=@5,[sequence]=@7,[CategoryId]=@8 where [Id]=@6"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { sweetMessage("", "SubCategory Updated Successfully", "success"); Response.Redirect("SubCategory.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } else { string query = "INSERT INTO [dbo].[tblSubCategory] ([SubCategory] ,[Description],[CategoryId],[IsActive],[IsDeleted],[CreatedOn],[CreatedBy],[sequence]) " + " VALUES ('" + txtSubCategoryName.Text.ToString().Replace("'", "''") + "','" + txtDescription.Text.ToString().Replace("'", "''") + "','" + categoryId + "'," + IsActive + ",0,'" + dt.ToString() + "'," + userId + "," + txtSequence.Text + ")"; int VAL = dbc.ExecuteQuery(query); if (VAL > 0) { sweetMessage("", "SubCategory Added Successfully", "success"); Response.Redirect("SubCategory.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
protected void Button3_Click(object sender, EventArgs e) { try { if (Request.QueryString["Id"] != "" && Request.QueryString["Id"] != null) { if (!lblTempleteID.Text.Equals("")) { try { string[] param = { txtname.Text, txtSubject.Text, txtFullDescription.Text, chkisActive.Checked ? "1" : "0", "0", cmbMailAccount.Value, "0", "1", lblTempleteID.Text }; string updateTemplete = @"UPDATE [MessageTemplate] SET [Name] = @1 ,[Subject] = @2 ,[Body] = @3 ,[IsActive] =@4 ,[AttachedDownloadId] = @5 ,[EmailAccountId] =@6 ,[LimitedToStores] = @7,[Priority] = @8 WHERE Id=@9"; dbCon.ExecuteQueryWithParams(updateTemplete, param); } catch (Exception) { } } } else { try { string[] param = { txtname.Text, txtSubject.Text, txtFullDescription.Text, chkisActive.Checked ? "1" : "0", "0", cmbMailAccount.Value, "0", "1" }; string insertTemplet = @"INSERT INTO [MessageTemplate] ([Name],[Subject],[Body],[IsActive],[AttachedDownloadId],[EmailAccountId],[LimitedToStores],[Priority]) VALUES(@1,@2,@3,@4,@5,@6,@7,@8)"; int v = dbCon.ExecuteQueryWithParams(insertTemplet, param); } catch (Exception) { } } } catch (Exception) { } }
public double SendNotificationEmail(string subject, string body, string Priority, string From, string FromName, string To, string ToName, string EmailAccountId) { dbConnection dbc = new dbConnection(); string InsertEmail = ""; int rest = 0; try { InsertEmail = "INSERT INTO dbo.QueuedEmail([Priority],[From],FromName,[To],ToName,[Subject],Body,CreatedOnUtc,EmailAccountId,AttachedDownloadId,SentTries,isSent,inProcess,AttachmentFileName,AttachmentFilePath) VALUES(@1,@2,@3,@4,@5,@6,@7,GETUTCDATE(),@8,0,0,0,0,@9,@10)"; string[] parm = { Priority, From, FromName, To, ToName, subject, body, EmailAccountId, "", "" }; rest = dbc.ExecuteQueryWithParams(InsertEmail, parm); } catch (Exception err) { //Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Error, InsertEmail, 0, false, "1.Qued Email Customer", " "); } return(rest); }
public static void InsertLogsApp(String detailmsg) { dbConnection dbc = new dbConnection(); try { string[] insert = { detailmsg }; string cmd = "INSERT INTO [dbo].[ErrorLogs] ([Detail],[DOC]) VALUES (@1,DATEADD(MINUTE, 330, GETUTCDATE()))"; int value = dbc.ExecuteQueryWithParams(cmd, insert); } catch (Exception ex) { } finally { dbc.closeConnection(); } }
protected void Save_Click(object sender, EventArgs e) { Customerid = clsCommon.getCurrentCustomer().id; string fname = txtfname.Text; string lname = txtlname.Text; string email = txtemail.Text; string cityid = (ddlcity.SelectedValue).ToString(); //string cityid = ddlcity.SelectedItem.ToString(); string stateid = (ddlstate.SelectedValue).ToString(); String querynew = "UPDATE [dbo].[Customer] SET [FirstName] = @1 ,[LastName]= @2,[Email] = @3 ,[CityId]=@4 ,[StateId]=@5 WHERE [Id] = '" + Customerid + "'"; string[] parms_new = { fname, lname, email, cityid, stateid }; int resvaltrn = dbc.ExecuteQueryWithParams(querynew, parms_new); if (resvaltrn > 0) { Customerid = clsCommon.getCurrentCustomer().id; string qry = "select top 1 FirstName,LastName,(select CityName from CityMaster where Id= CityId) as CityName,(select StateName from StateMaster where Id= StateId) as stateName,Email,Mobile from Customer where Id=" + Customerid + "order by Id asc"; DataTable dtcust = dbc.GetDataTable(qry); if (dtcust.Rows.Count > 0 && dtcust != null) { name.InnerText = dtcust.Rows[0]["FirstName"].ToString() + " " + dtcust.Rows[0]["LastName"].ToString(); city.InnerText = dtcust.Rows[0]["CityName"].ToString(); state.InnerText = dtcust.Rows[0]["stateName"].ToString(); email11.InnerText = dtcust.Rows[0]["Email"].ToString(); mobile.InnerText = dtcust.Rows[0]["Mobile"].ToString(); } edittable.Visible = false; editsection.Visible = true; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); int IsActive = 0; string id1 = Request.QueryString["Id"]; string startdate = txtdt.Text.ToString(); string starttime = txttime.Text.ToString(); string enddate = txtdt1.Text.ToString(); string endtime = txttime1.Text.ToString(); string FROM1 = startdate + " " + starttime; string TO1 = enddate + " " + endtime; string[] validFileTypes = { "png", "jpg", "jpeg" }; Stream fs = FileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); Byte[] image = br.ReadBytes((Int32)fs.Length); string exten = System.IO.Path.GetExtension(FileUpload1.FileName); string name = System.IO.Path.GetFileName(FileUpload1.FileName); string ext = System.IO.Path.GetExtension(FileUpload1.FileName); bool isValidFile = false; string imgname = "", imgnamenew = ""; if (FileUpload1.HasFile) { for (int i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; break; } else { //lblmsg.Text = "Line : 349 : " + aa.Message; } } if (!isValidFile) { return; } ext = ext.Replace(".", "images/"); imgname = DateTime.Now.Ticks + exten; imgnamenew = FileUpload1.FileName; string path = Server.MapPath("/BannerImage"); FileUpload1.SaveAs(path + "/" + imgnamenew); } string fileName = ""; fileName = imgnamenew; if (chkisactive.Checked) { IsActive = 1; } string sCategoryId = ""; if (string.IsNullOrEmpty(ddlbasicCategory.SelectedValue)) { sCategoryId = "0"; } else { sCategoryId = ddlbasicCategory.SelectedValue.ToString(); } string sProductId = ""; if (string.IsNullOrEmpty(txtpname.Text)) { sProductId = "0"; } else { string productQry = " SELECT ID From Product WHERE Name = '" + txtpname.Text + "' AND IsDeleted=0 AND IsActive = 1"; DataTable dtProduct = dbc.GetDataTable(productQry); if (dtProduct.Rows.Count > 0) { sProductId = dtProduct.Rows[0]["ID"].ToString(); } } //sProductId = ddlbasicProduct.SelectedValue.ToString(); if (sProductId == "") { sweetMessage("", "Please select product from given list", "warning"); } else { int sActionId = 0; if (Convert.ToInt32(ddlbasicAction.SelectedValue) != 0) { sActionId = Convert.ToInt32(ddlbasicAction.SelectedValue); } List <ListItem> selectedIncharge = new List <ListItem>(); selectedIncharge = chklstBasicJurisdictionIncharge.Items.Cast <ListItem>().Where(n => n.Selected).ToList(); List <ListItem> selectedCategory = new List <ListItem>(); selectedCategory = chklstCategory.Items.Cast <ListItem>().Where(n => n.Selected).ToList(); if (BtnSave.Text.Equals("Update")) { string id = Request.QueryString["id"].ToString(); if (ddlBannerType.SelectedValue == "1") { string delJurisdictionBanner = " Delete FROM [dbo].[JurisdictionBanner] where BannerType = 'HomePage' AND BannerId=" + Convert.ToInt32(id); dbc.ExecuteQuery(delJurisdictionBanner); string delCategoryBannerLink = " Delete FROM [dbo].[tblCategoryBannerLink] where BannerType='HomePage' AND BannerId=" + Convert.ToInt32(id); dbc.ExecuteQuery(delCategoryBannerLink); if (fileName != "") { string[] para1 = { txtTitle1.Text, txtAltText.Text, txtbasicLink.Text, FROM1, TO1, IsActive.ToString(), fileName, dbc.getindiantime().ToString("dd-MMM-yyyy HH:mm:ss"), sCategoryId, sProductId, sActionId.ToString(), txtSequence.Text, id1 }; string query = "UPDATE [HomepageBanner] SET [Title]=@1,[AltText]=@2,[Link]=@3,[StartDate]=@4," + " [EndDate]=@5,[IsActive]=@6,[ImageName]=@7,[DOM]=@8,[CategoryId]=@9,[ProductId]=@10, [ActionId]=@11, [sequence]=@12 where [Id]=@13"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + id + "','" + dbc.getindiantimeString() + "'," + userId + ",'HomePage')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); if (cCategoryId != "0") { string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + id + "','" + dbc.getindiantimeString() + "'," + userId + ",1," + "'HomePage')"; dbc.ExecuteQuery(Categoryquery); } } sweetMessage("", "Banner Updated Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } } else if (fileName == "") { string[] para1 = { txtTitle1.Text, txtAltText.Text, txtbasicLink.Text, FROM1, TO1, IsActive.ToString(), dbc.getindiantime().ToString("dd-MMM-yyyy HH:mm:ss"), sCategoryId, sProductId, sActionId.ToString(), txtSequence.Text, id1 }; string query = "UPDATE [HomepageBanner] SET [Title]=@1,[AltText]=@2,[Link]=@3,[StartDate]=@4," + " [EndDate]=@5,[IsActive]=@6,[DOM]=@7,[CategoryId]=@8,[ProductId]=@9, [ActionId]=@10,[sequence]=@11 where [Id]=@12"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + id + "','" + dbc.getindiantimeString() + "'," + userId + ",'HomePage')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); if (cCategoryId != "0") { string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + id + "','" + dbc.getindiantimeString() + "'," + userId + ",1," + "'HomePage')"; dbc.ExecuteQuery(Categoryquery); } } sweetMessage("", "Banner Updated Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } else { string delJurisdictionBanner = " Delete FROM [dbo].[JurisdictionBanner] where BannerType='Intermediate' AND BannerId=" + Convert.ToInt32(id); dbc.ExecuteQuery(delJurisdictionBanner); string delCategoryBannerLink = " Delete FROM [dbo].[tblCategoryBannerLink] where BannerType='Intermediate' AND BannerId=" + Convert.ToInt32(id); dbc.ExecuteQuery(delCategoryBannerLink); if (fileName != "") { string[] para1 = { txtTitle1.Text, txtAltText.Text, txtbasicLink.Text, FROM1, TO1, IsActive.ToString(), fileName, dbc.getindiantimeString(), userId, sCategoryId, sActionId.ToString(), sProductId, txtSequence.Text, id1 }; string query = "UPDATE [IntermediateBanners] SET [Title]=@1,[AltText]=@2,[Link]=@3,[StartDate]=@4,[EndDate]=@5,[IsActive]=@6,[ImageName]=@7,[ModifiedOn]=@8,[ModifiedBy]=@9," + " [CategoryID]=@10,[ActionId]=@11,[ProductId]=@12, [sequence]=@13" + " where [Id]=@14"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + id1 + "','" + dbc.getindiantimeString() + "'," + userId + ",'Intermediate')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); if (cCategoryId != "0") { string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + id1 + "','" + dbc.getindiantimeString() + "'," + userId + ",1," + "'Intermediate')"; dbc.ExecuteQuery(Categoryquery); } } sweetMessage("", "Intermediate Updated Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } } else if (fileName == "") { string[] para1 = { txtTitle1.Text, txtAltText.Text, txtbasicLink.Text, FROM1, TO1, IsActive.ToString(), dbc.getindiantimeString(), userId, sCategoryId, sActionId.ToString(), sProductId, txtSequence.Text, id1 }; string query = "UPDATE [IntermediateBanners] SET [Title]=@1,[AltText]=@2,[Link]=@3,[StartDate]=@4,[EndDate]=@5,[IsActive]=@6,[ModifiedOn]=@7,[ModifiedBy]=@8, " + " [CategoryID]=@9,[ActionId]=@10,[ProductId]=@11, [sequence]=@12" + " where[Id] =@13"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + id1 + "','" + dbc.getindiantimeString() + "'," + userId + ",'Intermediate')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); if (cCategoryId != "0") { string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + id1 + "','" + dbc.getindiantimeString() + "'," + userId + ",1," + "'Intermediate')"; dbc.ExecuteQuery(Categoryquery); } } sweetMessage("", "Intermediate Banner Updated Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } } else { if (ddlBannerType.SelectedValue == "1") { string[] para1 = { txtTitle1.Text.ToString().Replace("'", "''"), txtAltText.Text.ToString().Replace("'", "''"), txtbasicLink.Text.ToString().Replace("'", "''"), FROM1, TO1, IsActive.ToString(), fileName, "0", dbc.getindiantimeString(), dbc.getindiantimeString(), sActionId.ToString(), sCategoryId, sProductId, txtSequence.Text }; //string query = "INSERT INTO [dbo].[HomepageBanner] ([Title] ,[AltText],[Link],[StartDate],[EndDate],[IsActive],[ImageName],[IsDeleted],[DOC],[DOM],[ActionId],[CategoryId],[ProductId]) VALUES ('" + txtTitle1.Text + "','" + txtAltText.Text + "','" + txtbasicLink.Text + "','" + FROM1 + "','" + TO1 + "','" + IsActive + "','" + fileName + "',0,'" + dbc.getindiantimeString() + "','" + dbc.getindiantimeString() + "',"+sActionId+","+sCategoryId+","+sProductId+")"; string query = "INSERT INTO [dbo].[HomepageBanner] ([Title] ,[AltText],[Link],[StartDate],[EndDate]," + " [IsActive],[ImageName],[IsDeleted],[DOC],[DOM],[ActionId],[CategoryId],[ProductId],[sequence])" + " VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14); SELECT SCOPE_IDENTITY();"; //int VAL = dbc.ExecuteQuery(query); int VAL = dbc.ExecuteQueryWithParamsId(query, para1); if (VAL > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + VAL + "','" + dbc.getindiantimeString() + "'," + userId + ",'HomePage')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); if (cCategoryId != "0") { string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + VAL + "','" + dbc.getindiantimeString() + "'," + userId + ",1" + ",'HomePage')"; dbc.ExecuteQuery(Categoryquery); } } sweetMessage("", "Banner Uploaded Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } else { string[] para1 = { txtTitle1.Text.ToString().Replace("'", "''"), txtAltText.Text.ToString().Replace("'", "''"), txtbasicLink.Text.ToString().Replace("'", "''"), FROM1, TO1, IsActive.ToString(), fileName, "0", ddlBannerType.SelectedValue, dbc.getindiantimeString(), userId, ddlbasicAction.SelectedItem.ToString(), sCategoryId, sActionId.ToString(), sProductId, txtSequence.Text }; string query = "INSERT INTO [dbo].[IntermediateBanners] ([Title] ,[AltText],[Link],[StartDate],[EndDate],[IsActive],[ImageName],"; query += "[IsDeleted],[TypeId],[CreatedOn],[CreatedBy],[Action],[CategoryID],[ActionId],[ProductId],[sequence]) VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); SELECT SCOPE_IDENTITY();"; //query += ddlintermediateType.SelectedValue.ToString() + "','" + dtCreatedon.ToString() + "'," + userId + ",'" + ddlintermedicateAction.SelectedItem.ToString() + "'," + sCategoryId + "," + intermediateActionId + "," + sProductId + "); SELECT SCOPE_IDENTITY();"; //int VAL = dbc.ExecuteQuery(query); int VAL = dbc.ExecuteQueryWithParamsId(query, para1); //query += "','" + FROM1 + "','" + TO1 + "','" + IsActive + "','" + fileName + "',0,'"; if (VAL > 0) { foreach (ListItem item in selectedIncharge) { string sJurisdictionId = item.Value.ToString(); string Jurisdictionquery = "INSERT INTO [dbo].[JurisdictionBanner] ([JurisdictionId] ,[BannerId],[CreatedOn],[CreatedBy],[BannerType])"; Jurisdictionquery += " VALUES ('" + sJurisdictionId + "','" + VAL + "','" + dbc.getindiantimeString() + "'," + userId + ",'Intermediate')"; dbc.ExecuteQuery(Jurisdictionquery); } foreach (ListItem item in selectedCategory) { string cCategoryId = item.Value.ToString(); string Categoryquery = "INSERT INTO [dbo].[tblCategoryBannerLink] ([CategoryId],[BannerId],[CreatedDate],[CreatedBy],[IsActive],[BannerType])"; Categoryquery += " VALUES ('" + cCategoryId + "','" + VAL + "','" + dbc.getindiantimeString() + "'," + userId + ",1" + ",'Intermediate')"; dbc.ExecuteQuery(Categoryquery); } sweetMessage("", "Intermediate Banner Added Successfully", "success"); Response.Redirect("HomePageBannerList.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
public int StoreNotificationScheduler(string NotificationTo, string SendTo, string Category, string Product, string Message, string MobileNumber, string NotificationType, string ScheduleTime, string exptime, string ImageUrl) { try { //string NotificationType = "15"; int userId = 0; int.TryParse(Request.Cookies["TUser"]["Id"], out userId); string ScheduleQuery = "INSERT INTO [dbo].[Sosho_Notification_Schedule] ([NotificationTo],[SendTo],[CategoryId],[ProductId],[ImageUrl],[Message],[NotificationType],[IsSend],[DOC],[DOM],[ExpiredTime],[SendBy],[ScheduleTime],DisplayExpiredTime) VALUES(@1,@2,@3,@4,@5,@6,@7,@8,CONVERT(DATETIME, '" + dbc.getDOCMtime() + "', 102),CONVERT(DATETIME, '" + dbc.getDOCMtime() + "', 102),CONVERT(DATETIME, '" + dbc.getindiantime().AddHours(24).ToString("yyyy-MM-dd HH:mm:ss") + "', 102),@9,'" + ScheduleTime + "','" + exptime + "')"; string[] parm = { NotificationTo, SendTo, "0", Product, ImageUrl, Message, Category, "0", userId.ToString() }; int rest = dbc.ExecuteQueryWithParams(ScheduleQuery, parm); if (rest > 0) { string qs2 = "SELECT IDENT_CURRENT('Sosho_Notification_Schedule')"; object objbid = dbc.ExecuteSQLScaler(qs2); int scheduleId = 0; int.TryParse(objbid.ToString(), out scheduleId); if (scheduleId > 0) { if (SendTo.Equals("1")) { string MobileQuery = "select *,iif(IsIOS = 1,1,0) as DeviceType from (select isnull(deviceid,'') as deviceid, isnull(fcmregistrationid,'') as fcmregistrationid, mobilenumber, [doc], dom, Id, IsIOS, (select top 1 isnull(Id,0) from Customer where Mobile = mobilenumber) as CustomerId from [dbo].[DevicedetailsCustomer] where mobilenumber in (" + MobileNumber + ")) as finalData where CustomerId <> 0 AND deviceid <> '' AND fcmregistrationid <> '' Order by mobilenumber"; DataTable dtMob = dbc.GetDataTable(MobileQuery); if (dtMob.Rows.Count > 0) { for (int i = 0; i < dtMob.Rows.Count; i++) { string InertScheduleDetail = "INSERT INTO [dbo].[Sosho_Notification_Schedule_Detail] ([ScheduleID],[DeviceId],[FCMRegistrationId],[Message],[ResponseId],[Type],[DOC],[Mobile],[isSend],[isSuccess],[delivered],[opentime],[DeviceType],[CustomerId],[ExpiredTime]) VALUES (@1,@2,@3,@4,'',@5,CONVERT(DATETIME, '" + dbc.getDOCMtime() + "', 102),@6,0,0,'','',@7,@8,@9)"; string[] parmdata = { scheduleId.ToString(), dtMob.Rows[i]["deviceid"].ToString(), dtMob.Rows[i]["fcmregistrationid"].ToString(), Message, NotificationType, dtMob.Rows[i]["mobilenumber"].ToString(), dtMob.Rows[i]["DeviceType"].ToString(), dtMob.Rows[i]["CustomerId"].ToString(), exptime }; int restdet = dbc.ExecuteQueryWithParams(InertScheduleDetail, parmdata); } return(1); } else { return(0); } } else { return(1); // Send To All Mobile Details Store Via Scheduler } } else { return(0); } } else { return(0); } } catch (Exception ex) { return(-1); } }
protected void cmdSave_Click(object sender, EventArgs e) { try { if (Request.QueryString.AllKeys.Contains("ID")) { if (!Request.QueryString["ID"].ToString().Equals("")) { if (txtusername.Text.Trim() != "" && txtpwd.Text.Trim() != "" && txtnumber.Text.Trim() != "") { DataTable dtcheck = dbc.GetDataTable("select * from Users where UserName = '******' and id <> " + Request.QueryString["ID"].ToString() + ""); if (dtcheck.Rows.Count > 0) { ltrErr.Text = "Username already exist, Please use different username."; return; } string[] ins = { txtusername.Text.Trim(), txtpwd.Text.Trim(), txtnumber.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("update Users set Username=@1,Password=@2,mobile_number=@3 where id=" + Request.QueryString["ID"].ToString() + "", ins); if (i > 0) { Response.Redirect("~/RoleManagement/User.aspx", false); } } else { getdata(); ltrErr.Text = "Please fill all details"; } } } else { if (txtusername.Text.Trim() != "" && txtpwd.Text.Trim() != "" && txtnumber.Text.Trim() != "") { DataTable dtcheck = dbc.GetDataTable("select * from Users where UserName = '******' "); if (dtcheck.Rows.Count > 0) { ltrErr.Text = "Username already exist, Please use different username."; return; } string[] ins = { txtusername.Text.Trim(), txtpwd.Text.Trim(), txtnumber.Text.Trim() }; int i = dbc.ExecuteQueryWithParams("insert into Users (Username,Password,mobile_number) values(@1,@2,@3)", ins); if (i > 0) { getdata(); ltrErr.Text = "Inserted Successfully"; txtusername.Text = ""; txtpwd.Text = ""; txtnumber.Text = ""; } else { getdata(); ltrErr.Text = "Not Inserted"; } } else { getdata(); ltrErr.Text = "Please fill all details"; } } } catch (Exception ex) { ltrErr.Text = ex.Message; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); int IsActive = 0; DateTime dt = DateTime.Now; if (chkisactive.Checked) { IsActive = 1; } string[] para1 = { txtJurisdictionIncharge.Text.ToString().Replace("'", "''"), txtContact.Text.ToString().Replace("'", "''"), txtEmailId.Text.ToString().Replace("'", "''"), ddlState.SelectedItem.Value, ddlCity.SelectedItem.Value, txtComments.Text.ToString().Replace("'", "''"), IsActive.ToString(), dt.ToString(), userId }; if (BtnSave.Text.Equals("Update")) { string id = Request.QueryString["id"].ToString(); string query = " UPDATE [JurisdictionMaster] SET [JurisdictionIncharge]=@1,[Contact]=@2,[EmalID]=@3,[StateId]=@4,[CityId]=@5,[Comments]=@6, " + " [IsActive] = @7,[CreatedOn] = @8,[CreatedBy] = @9 WHERE JurisdictionID = " + id; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { string updateUser = "******" + txtUserName.Text.ToString() + "',[Password]='" + txtPassword.Text.ToString() + "'," + " [Name]='" + txtUserName.Text.ToString() + "',[UserType]=2,[JurisdictionID]=" + id + ",[Mobile] = '" + txtContact.Text.ToString() + "'" + " WHERE JurisdictionID = " + id; int userVAL = dbc.ExecuteQuery(updateUser); sweetMessage("", "Jurisdiction Updated Successfully", "success"); Response.Redirect("Jurisdiction.aspx"); } } else { string query1 = "INSERT INTO [JurisdictionMaster] ([JurisdictionIncharge],[Contact],[EmalID],[StateId],[CityId],[Comments],[IsActive],[CreatedOn],[CreatedBy]) VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9); SELECT SCOPE_IDENTITY();"; int VAL = dbc.ExecuteQueryWithParamsId(query1, para1); if (VAL > 0) { string InsertJDetailqry = ""; List <ListItem> selectedPincode = new List <ListItem>(); selectedPincode = chklstPincode.Items.Cast <ListItem>().Where(n => n.Selected).ToList(); foreach (ListItem item in selectedPincode) { InsertJDetailqry = "INSERT INTO [JurisdictionDetail] ([JurisdictionID],[PinCodeID],[IsActive],[CreatedOn],[CreatedBy]) VALUES ('" + VAL + "','" + item + "'," + IsActive + ",'" + dt + "'," + userId + ")"; int VAL1 = dbc.ExecuteQuery(InsertJDetailqry); } if (Convert.ToInt32(VAL) > 0) { hdnJurisdictionID.Value = VAL.ToString(); hdnContact.Value = txtContact.Text.ToString().Replace("'", "''"); string InsertUserqry = "INSERT INTO [Users] ([UserName],[Password],[Name],[UserType],[JurisdictionID],[Mobile]) VALUES ('" + txtUserName.Text.ToString().Replace("'", "''") + "','" + txtPassword.Text.ToString().Replace("'", "''") + "','" + txtUserName.Text.ToString().Replace("'", "''") + "',2," + VAL.ToString() + "," + txtContact.Text.ToString() + ")"; int userVAL = dbc.ExecuteQuery(InsertUserqry); sweetMessage("", "Jurisdiction Added Successfully", "success"); Response.Redirect("Jurisdiction.aspx"); } else { hdnJurisdictionID.Value = "0"; sweetMessage("", "Please Try Again!!", "warning"); } } else { sweetMessage("", "Please Try Again!!", "warning"); } } //string InsertJurisdictionMasterqry = "INSERT INTO [JurisdictionMaster] ([JurisdictionIncharge],[Contact],[EmalID],[StateId],[CityId],[Comments],[IsActive],[CreatedOn],[CreatedBy]) VALUES ('" + txtJurisdictionIncharge.Text.ToString().Replace("'", "''") + "','" + txtContact.Text.ToString().Replace("'", "''") + "','" + txtEmailId.Text.ToString().Replace("'", "''") + "'," + ddlState.SelectedItem.Value + "," + ddlCity.SelectedItem.Value + ",'" + txtComments.Text.ToString().Replace("'", "''") + "'," + IsActive + ",'" + dt + "'," + userId + ")"; //int VAL = dbc.ExecuteQuery(InsertJurisdictionMasterqry); } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
public PlaceOrderModel PlaceOrder(String CustomerId, decimal PaidAmount, string AddressId, string Quantity, string buywith, string discountamount = "", string Redeemeamount = "", string couponCode = "") { PlaceOrderModel objplaceorder = new PlaceOrderModel(); try { string merchantTxnId = dbCon.getindiantime().ToString("yyyyMMddHHmmssffff") + CustomerId; if(PaidAmount==0) { int result = dbCon.CreateTransaction(merchantTxnId, CustomerId, PaidAmount); if (result == 1) { string chektrans = "select id from AlterNetOrder where trnid=@1"; string[] param = { merchantTxnId }; DataTable dtcheckTrans = dbCon.GetDataTableWithParams(chektrans, param); if (dtcheckTrans != null && dtcheckTrans.Rows.Count > 0) { dbCon.deleteAlternateOrder(merchantTxnId); } else { int chkalternat = CreateAlternateOrder(CustomerId, merchantTxnId, AddressId, PaidAmount.ToString(), Quantity, buywith, discountamount, Redeemeamount, couponCode); if (chkalternat > 0 && PaidAmount == 0) { int OrderId = WalletPlaceOrder(merchantTxnId); if (OrderId > 0) { // if success, Update the transaction #region Update Transaction try { String querynew = "UPDATE [dbo].[CitrusPayment] SET [OrderId] = @1 ,[Order_TimeOfTransaction]= @2,[Statuse] = @3 ,[IsPaymentSuccess]=@4 WHERE [TxnId] = '" + merchantTxnId + "'"; string[] parms_new = { OrderId.ToString(), dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "3", "1" }; int resvaltrn = dbCon.ExecuteQueryWithParams(querynew, parms_new); if (resvaltrn > 0) { String querynew1 = "UPDATE [dbo].[AlternetOrder] SET [UpdatedOnUtc]=@1,[IsPaymentDone]=@2 WHERE [TrnId] = '" + merchantTxnId + "'"; string[] parms_new1 = { dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "1" }; int resvaltrn1 = dbCon.ExecuteQueryWithParams(querynew1, parms_new1); if (resvaltrn1 > 0) { String querynew2 = "UPDATE [dbo].[Order] SET [UpdatedOnUtc] =@1,[IsPaymentDone]=@2 WHERE [TRNID] ='" + merchantTxnId + "'"; string[] parms_new2 = { dbCon.getindiantime().ToString("dd/MMM/yyyy HH:mm:ss"), "1" }; int resvaltrn2 = dbCon.ExecuteQueryWithParams(querynew2, parms_new2); if (resvaltrn2 > 0) { objplaceorder.resultflag = "1"; objplaceorder.OrderId = OrderId.ToString(); objplaceorder.Message = "Your OrderNo:" + OrderId + " has been succesfully generated"; } } } else { objplaceorder.resultflag = "1"; objplaceorder.OrderId = OrderId.ToString(); objplaceorder.Message = "Your Order was Not Generated"; } } catch (Exception err) { objplaceorder.resultflag = "1"; objplaceorder.OrderId = OrderId.ToString(); objplaceorder.Message = "Your Order was Not Generated"; } #endregion } else { objplaceorder.resultflag = "1"; objplaceorder.OrderId = OrderId.ToString(); objplaceorder.Message = "Your Order was Not Generated"; } } else { objplaceorder.resultflag = "0"; objplaceorder.Message = "Your Order was Not Generated"; } } } } } catch(Exception ex) { } return objplaceorder; }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); int IsActive = 0; string id1 = Request.QueryString["Id"]; if (chkisactive.Checked) { IsActive = 1; } string sSuperFranchiseeId = ""; if (string.IsNullOrEmpty(ddlSuperFranchisee.SelectedValue)) { sSuperFranchiseeId = "0"; } else { sSuperFranchiseeId = ddlSuperFranchisee.SelectedValue.ToString(); } string qrCodeURL = _QRCODEURL.Replace("#QRCODE#", txtCustomerCode.Text); qrCodeURL = qrCodeURL.Replace("#FNAME#", "&utm_campaign=" + txtMasterFranchiseeName.Text); qrCodeURL = _QRCodeStaticURL + "&referrer=utm_source=" + HttpUtility.UrlEncode(qrCodeURL); if (BtnSave.Text.Equals("Update")) { string[] para1 = { txtMasterFranchiseeName.Text, txtContactNumber.Text, txtEmailAddress.Text, txtCustomerCode.Text, txtShortUrl.Text, IsActive.ToString(), sSuperFranchiseeId, dbc.getindiantime().ToString("dd-MMM-yyyy HH:mm:ss"), qrCodeURL, id1 }; string query = "UPDATE [MasterFranchisee] SET [MasterFranchiseeName]=@1,[MasterFranchiseeContactNumber]=@2,[MasterFranchiseeEmailAddress]=@3,[MasterFranchiseeCustomerCode]=@4," + " [ShortUrl]=@5,[IsActive]=@6,[SuperFranchiseeID]=@7,[CreatedOn]=@8,[QRCodeUrl]=@9 where [MasterFranchiseeID]=@10"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { string updateUser = "******" + txtUserName.Text.ToString() + "',[Password]='" + txtPassword.Text.ToString() + "'," + " [Name]='" + txtUserName.Text.ToString() + "',[UserType]=5,[FranchiseeId]=" + id1 + ",[Mobile] = '" + txtContactNumber.Text.ToString() + "'" + " WHERE FranchiseeId = " + id1; int userVAL = dbc.ExecuteQuery(updateUser); sweetMessage("", "Master Franchisee Updated Successfully", "success"); Response.Redirect("MasterFranchiseeList.aspx", true); } } else { byte[] QRCodebyteImage = GenerateQRCode(qrCodeURL); string newfileName = txtMasterFranchiseeName.Text + "_" + txtCustomerCode.Text; newfileName = newfileName.Replace(" ", String.Empty); string filepath = "~/Content/images/QRCodeImages/" + newfileName + ".png"; string tempFile = HttpContext.Current.Server.MapPath(filepath); using (var ms = new MemoryStream(QRCodebyteImage)) { using (FileStream fs = File.Create(tempFile, 1024)) { ms.WriteTo(fs); } ms.Close(); ms.Flush(); } string[] para1 = { txtMasterFranchiseeName.Text.ToString().Replace("'", "''"), txtContactNumber.Text.ToString().Replace("'", "''"), txtEmailAddress.Text.ToString().Replace("'", "''"), txtCustomerCode.Text.ToString().Replace("'", "''"), txtShortUrl.Text.ToString(), IsActive.ToString(), sSuperFranchiseeId, dbc.getindiantimeString(), "0", qrCodeURL, filepath }; string query = "INSERT INTO [dbo].[MasterFranchisee] ([MasterFranchiseeName] ,[MasterFranchiseeContactNumber],[MasterFranchiseeEmailAddress],[MasterFranchiseeCustomerCode]," + " [ShortUrl],[IsActive],[SuperFranchiseeID],[CreatedOn],[IsDeleted],[QRCodeUrl],[QrCodeImage])" + " VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11); SELECT SCOPE_IDENTITY();"; int VAL = dbc.ExecuteQueryWithParamsId(query, para1); if (VAL > 0) { hdnFranchiseeID.Value = VAL.ToString(); hdnContact.Value = txtContactNumber.Text.ToString().Replace("'", "''"); string InsertUserqry = "INSERT INTO [Users] ([UserName],[Password],[Name],[UserType],[FranchiseeId],[Mobile]) VALUES ('" + txtUserName.Text.ToString().Replace("'", "''") + "','" + txtPassword.Text.ToString().Replace("'", "''") + "','" + txtUserName.Text.ToString().Replace("'", "''") + "',5," + VAL.ToString() + ",'" + txtContactNumber.Text.ToString() + "')"; int userVAL = dbc.ExecuteQuery(InsertUserqry); sweetMessage("", "Master Franchisee Uploaded Successfully", "success"); Response.Redirect("MasterFranchiseeList.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
protected void PaytmButton_Click(object sender, EventArgs e) { Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, "", 2, false, "1.Trn came to make payment for: Paytm", "1"); #region Paytm //antony commented for testing Dictionary <string, string> parameters = new Dictionary <string, string>(); decimal orderamnt = 0; string email = string.Empty; string mobilenumber = string.Empty; string C_id = string.Empty; string ordrid = string.Empty; try { Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, "", 2, false, "1.Trn came to make payment for: Paytm", "2"); string qry = "select PaidAmount,AddressId from [AlterNetOrder] where TrnId='" + txnId + "'"; DataTable dtorderdetails = dbCon.GetDataTable(qry); if (dtorderdetails != null & dtorderdetails.Rows.Count > 0) { Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, "", 2, false, "1.Trn came to make payment for: Paytm", "3"); bool o = decimal.TryParse(dtorderdetails.Rows[0]["PaidAmount"].ToString(), out orderamnt); string qryadd = "select CustomerId,MobileNo,Email from CustomerAddress where Id=" + dtorderdetails.Rows[0]["AddressId"].ToString() + ""; DataTable dtadddetails = dbCon.GetDataTable(qryadd); if (dtadddetails != null & dtadddetails.Rows.Count > 0) { Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, "", 2, false, "1.Trn came to make payment for: Paytm", "4"); email = dtadddetails.Rows[0]["Email"].ToString(); mobilenumber = dtadddetails.Rows[0]["MobileNo"].ToString(); C_id = dtadddetails.Rows[0]["CustomerId"].ToString(); ordrid = txnId; Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, "", 2, false, "1.Trn came to make payment for: Paytm", "5"); } } //email = "*****@*****.**"; //mobilenumber = "1616161616"; //C_id = "1"; //ordrid = "2019091715301218131"; } catch (Exception err) { Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Error, ordrid, 2, false, "1.Trn came to make payment for PATM:ERROR", "MSG: " + err.Message.ToString()); } Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Information, ordrid, 2, false, "1.Trn came to make payment for PAYTM", " "); if (orderamnt > 0 && !String.IsNullOrEmpty(ordrid) && !String.IsNullOrEmpty(email) && !String.IsNullOrEmpty(C_id)) { //orderamnt = 1; //REMOVE try { String Str1 = "UPDATE [dbo].[CitrusPayment] SET [Payment_Method_Id] = @1 ,[Cit_TimeOfTransaction] = DATEADD(MINUTE, 330, GETUTCDATE()) ,[HasGone] = @2,[IsRecordsFetchedFromCitrus]= @3, [GoneTime] = DATEADD(MINUTE, 330, GETUTCDATE()) WHERE [TxnId] = '" + ordrid + "'"; string[] parm = { "2", "1", "0" }; int resval = dbCon.ExecuteQueryWithParams(Str1, parm); if (resval > 0) { String Str2 = "UPDATE [dbo].[AlterNetOrder] SET [PaymentGatewayId] = @1 ,[UpdatedOnUtc] = DATEADD(MINUTE, 330, GETUTCDATE()) WHERE [TrnId] = '" + ordrid + "'"; string[] parm2 = { "2" }; int resval2 = dbCon.ExecuteQueryWithParams(Str2, parm2); if (resval2 > 0) { String Str3 = "UPDATE [dbo].[Order] SET [PaymentGatewayId] = @1 ,[UpdatedOnUtc] = DATEADD(MINUTE, 330, GETUTCDATE()) WHERE [TRNID] = '" + ordrid + "'"; string[] parm3 = { "2" }; int resval3 = dbCon.ExecuteQueryWithParams(Str3, parm3); } } } catch (Exception err) { } #region paytm string PayAmt = String.Format("{0:0.00}", orderamnt); parameters.Add("MID", Constant.Message.PAYTM_MID); parameters.Add("CHANNEL_ID", Constant.Message.PAYTM_channel_id); parameters.Add("INDUSTRY_TYPE_ID", Constant.Message.PAYTM_Industry_Type); parameters.Add("WEBSITE", Constant.Message.PAYTM_website); parameters.Add("EMAIL", email); parameters.Add("MOBILE_NO", mobilenumber); parameters.Add("CUST_ID", C_id); parameters.Add("ORDER_ID", ordrid); parameters.Add("TXN_AMOUNT", PayAmt); parameters.Add("CALLBACK_URL", Constant.Message.PG_ReturnURL_Paym); //This parameter is not mandatory. Use this to pass the callback url dynamically. //if (_customerService.IsCustomerEligibleto_Paytm_Promo(_workContext.CurrentCustomer.Id)) //{ // parameters.Add("PROMO_CAMP_ID", "PAYTMSB"); //} string getCheckSum = dbCon.genCheckSum(parameters, Constant.Message.PAYTM_merchantKey); parameters.Add("CHECKSUMHASH", getCheckSum); String paytm_trnid = string.Empty; paytm_trnid = ordrid; string outputHTML = "<html>"; outputHTML += "<head>"; outputHTML += "<title>SaleBhai Check Out Page</title>"; outputHTML += "</head>"; outputHTML += "<body>"; outputHTML += "<center><h1>Please do not refresh this page...</h1></center>"; outputHTML += "<form method='post' action='" + Constant.Message.PAYTM_URL + ordrid + "' name='f1'>"; outputHTML += "<table border='1'>"; outputHTML += "<tbody>"; foreach (string key in parameters.Keys) { outputHTML += "<input type='hidden' name='" + key + "' value='" + parameters[key] + "'>"; } outputHTML += "<input type='hidden' name='CHECKSUMHASH' value='" + getCheckSum + "'>"; outputHTML += "</tbody>"; outputHTML += "</table>"; outputHTML += "<script type='text/javascript'>"; outputHTML += "document.f1.submit();"; outputHTML += "</script>"; outputHTML += "</form>"; outputHTML += "</body>"; outputHTML += "</html>"; Response.Write(outputHTML); #endregion } else { //SOME VALUE IS MISSING Logger.InsertLogs(InvoiceLOGS.InvoiceLogLevel.Error, "", 2, false, "1.Trn came to make payment for: PAYTM", "Email = " + email + ",Custid = " + C_id.ToString() + ",mobile = " + mobilenumber + ",trnid" + ordrid); } #endregion }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); int IsActive = 0; DateTime dt = DateTime.Now; if (chkisactive.Checked) { IsActive = 1; } string[] para1 = { txtDeliveryIncharge.Text.ToString().Replace("'", "''"), txtContact.Text.ToString().Replace("'", "''"), txtEmailId.Text.ToString().Replace("'", "''"), ddlState.SelectedItem.Value, ddlCity.SelectedItem.Value, txtComments.Text.ToString().Replace("'", "''"), IsActive.ToString(), dt.ToString(), userId }; if (BtnSave.Text.Equals("Update")) { string id = Request.QueryString["id"].ToString(); //string delDeliveryDetail = " DELETE FROM DeliveryDetail WHERE DeliveryId = " + id; //dbc.ExecuteQuery(delDeliveryDetail); //int areaId = Convert.ToInt32(ddlArea.SelectedValue); //string pincode = string.Empty; //string pincodeQry = " SELECT Top 1 zipCode FROM ZipCode WHERE Id = " + areaId; //DataTable dtPincode = dbc.GetDataTable(pincodeQry); //if (dtPincode.Rows.Count > 0) //{ // pincode = dtPincode.Rows[0]["zipcode"].ToString(); //} //string InsertDetailqry = ""; //List<ListItem> selectedArea = new List<ListItem>(); //selectedArea = chklstArea.Items.Cast<ListItem>().Where(n => n.Selected).ToList(); //foreach (ListItem item in selectedArea) //{ // InsertDetailqry = "INSERT INTO [DeliveryDetail] ([DeliveryID],[PinCodeID],[AreaId],[BuildingId],[IsActive],[CreatedOn],[CreatedBy]) VALUES ('" + id + "','" + pincode + "'," + areaId + "," + item.Value + "," + IsActive + ",'" + dt + "'," + userId + ")"; // dbc.ExecuteQuery(InsertDetailqry); //} string query = " UPDATE [DeliveryMaster] SET [DeliveryIncharge]=@1,[Contact]=@2,[EmalID]=@3,[StateId]=@4,[CityId]=@5,[Comments]=@6, " + " [IsActive] = @7,[CreatedOn] = @8,[CreatedBy] = @9 WHERE DeliveryId = " + id; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { string updateUser = "******" + txtUserName.Text.ToString() + "',[Password]='" + txtPassword.Text.ToString() + "'," + " [Name]='" + txtUserName.Text.ToString() + "',[UserType]=3,[DeliveryID]=" + id + ",[Mobile] = '" + txtContact.Text.ToString() + "'" + " WHERE DeliveryId = " + id; int userVAL = dbc.ExecuteQuery(updateUser); sweetMessage("", "Delivery Updated Successfully", "success"); Response.Redirect("Delivery.aspx"); } } else { string query1 = "INSERT INTO [DeliveryMaster] ([DeliveryIncharge],[Contact],[EmalID],[StateId],[CityId],[Comments],[IsActive],[CreatedOn],[CreatedBy]) VALUES (@1,@2,@3,@4,@5,@6,@7,@8,@9); SELECT SCOPE_IDENTITY();"; int VAL = dbc.ExecuteQueryWithParamsId(query1, para1); if (VAL > 0) { int areaId = Convert.ToInt32(ddlArea.SelectedValue); string pincode = string.Empty; string pincodeQry = " SELECT Top 1 zipCode FROM ZipCode WHERE Id = " + areaId; DataTable dtPincode = dbc.GetDataTable(pincodeQry); if (dtPincode.Rows.Count > 0) { pincode = dtPincode.Rows[0]["zipcode"].ToString(); } string InsertDetailqry = ""; List <ListItem> selectedArea = new List <ListItem>(); selectedArea = chklstArea.Items.Cast <ListItem>().Where(n => n.Selected).ToList(); foreach (ListItem item in selectedArea) { InsertDetailqry = "INSERT INTO [DeliveryDetail] ([DeliveryID],[PinCodeID],[AreaId],[BuildingId],[IsActive],[CreatedOn],[CreatedBy]) VALUES ('" + VAL + "','" + pincode + "'," + areaId + "," + item.Value + "," + IsActive + ",'" + dt + "'," + userId + ")"; dbc.ExecuteQuery(InsertDetailqry); } if (Convert.ToInt32(VAL) > 0) { hdnDeliveryID.Value = VAL.ToString(); hdnContact.Value = txtContact.Text.ToString().Replace("'", "''"); string InsertUserqry = "INSERT INTO [Users] ([UserName],[Password],[Name],[UserType],[DeliveryID],[Mobile]) VALUES ('" + txtUserName.Text.ToString().Replace("'", "''") + "','" + txtPassword.Text.ToString().Replace("'", "''") + "','" + txtUserName.Text.ToString().Replace("'", "''") + "',3," + VAL.ToString() + ",'" + txtContact.Text.ToString() + "')"; int userVAL = dbc.ExecuteQuery(InsertUserqry); sweetMessage("", "Delivery Added Successfully", "success"); Response.Redirect("Delivery.aspx"); } else { hdnDeliveryID.Value = "0"; sweetMessage("", "Please Try Again!!", "warning"); } } else { sweetMessage("", "Please Try Again!!", "warning"); } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string userId = Request.Cookies["TUser"]["Id"].ToString(); int IsActive = 0, IsDefault = 0; string[] validFileTypes = { "png", "jpg", "jpeg" }; Stream fs = FileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); Byte[] image = br.ReadBytes((Int32)fs.Length); string exten = System.IO.Path.GetExtension(FileUpload1.FileName); string name = System.IO.Path.GetFileName(FileUpload1.FileName); string ext = System.IO.Path.GetExtension(FileUpload1.FileName); bool isValidFile = false; string imgname = "", imgnamenew = ""; if (FileUpload1.HasFile) { for (int i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; break; } else { //lblmsg.Text = "Line : 349 : " + aa.Message; } } if (!isValidFile) { return; } ext = ext.Replace(".", "images/"); imgname = DateTime.Now.Ticks + exten; imgnamenew = FileUpload1.FileName; string path = Server.MapPath("/CategoryImage"); FileUpload1.SaveAs(path + "/" + imgnamenew); } string fileName = ""; fileName = imgnamenew; if (chkisactive.Checked) { IsActive = 1; } if (chkIsDefault.Checked) { IsDefault = 1; } DateTime dt = DateTime.Now; if (BtnSave.Text.Equals("Update")) { if (IsDefault == 1) { string updateQry = " UPDATE [Category] SET IsDefault = 0 "; dbc.ExecuteQuery(updateQry); } string id = Request.QueryString["id"].ToString(); if (fileName != "") { string[] para1 = { txtCategoryName.Text, txtDescription.Text, IsActive.ToString(), fileName, dt.ToString(), userId, id, txtSequence.Text, IsDefault.ToString() }; string query = "UPDATE [Category] SET [CategoryName]=@1,[CategoryDescription]=@2,[IsActive]=@3,[CategoryImage]=@4,[ModifiedOn]=@5,[ModifiedBy]=@6,[sequence]=@8, [IsDefault]=@9 where [CategoryID]=@7"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { sweetMessage("", "Category Updated Successfully", "success"); Response.Redirect("Category.aspx", true); } } else if (fileName == "") { string[] para1 = { txtCategoryName.Text, txtDescription.Text, IsActive.ToString(), dt.ToString(), userId, id, txtSequence.Text, IsDefault.ToString() }; string query = "UPDATE [Category] SET [CategoryName]=@1,[CategoryDescription]=@2,[IsActive]=@3,[ModifiedOn]=@4,[ModifiedBy]=@5,[sequence]=@7, [IsDefault]=@8 where [CategoryID]=@6"; int v1 = dbc.ExecuteQueryWithParams(query, para1); if (v1 > 0) { sweetMessage("", "Category Updated Successfully", "success"); Response.Redirect("Category.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } else { if (IsDefault == 1) { string updateQry = " UPDATE [Category] SET IsDefault = 0 "; dbc.ExecuteQuery(updateQry); } string query = "INSERT INTO [dbo].[Category] ([CategoryName] ,[CategoryDescription],[CategoryImage],[IsActive],[IsDeleted],[CreatedOn],[CreatedBy],[sequence],[IsDefault]) VALUES ('" + txtCategoryName.Text.ToString().Replace("'", "''") + "','" + txtDescription.Text.ToString().Replace("'", "''") + "','" + fileName + "'," + IsActive + ",0,'" + dt.ToString() + "'," + userId + "," + txtSequence.Text + "," + IsDefault + ")"; int VAL = dbc.ExecuteQuery(query); if (VAL > 0) { sweetMessage("", "Category Added Successfully", "success"); Response.Redirect("Category.aspx", true); } else { sweetMessage("", "Please Try Again!!", "warning"); } } } catch (Exception E) { sweetMessage("", "Please Try Again!!", "warning"); } }