private bool SaveRecords(enmSaveType enType) { try { string strInactivFlag = "0"; string strNewDate = ""; string newsValidityDate =""; string strFileName = ""; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; if (!string.IsNullOrWhiteSpace(txtNewsDate.Text)) strNewDate = txtNewsDate.Text.Substring(6, 4) + "/" + txtNewsDate.Text.Substring(3, 2) + "/" + txtNewsDate.Text.Substring(0, 2); if (!string.IsNullOrWhiteSpace(txtValidity.Text)) newsValidityDate ="'"+ txtValidity.Text.Substring(6, 4) + "/" + txtValidity.Text.Substring(3, 2) + "/" + txtValidity.Text.Substring(0, 2)+"'"; else newsValidityDate = "NULL"; //UPLOAD ATTACHMENT FILE TO SERVER if (fuAttachment.HasFile) { strFileName = fuAttachment.FileName; objGen.gUploadFiles(strUploadAttachmentPath, fuAttachment, this); } else strFileName = objGen.gReplaceQuotes(txtAttachmentFile.Text); //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_BUSINESS_NEWS (NEWS_SOURCE ,NEWS_CAPTION ,NEWS_DATE ,NEWS_VALIDITY_DATE ,COUNTRY ,CITY ,NEWS_DESCRIPTION ,ATTACHMENT ,INACTIVE_FLAG) VALUES('" + objGen.gReplaceQuotes(txtSource.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtCaption.Text.Trim()) + @"', '" + strNewDate + @"', " + newsValidityDate + @", '" + objGen.gReplaceQuotes(txtCountry.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtCity.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtNewsDetails.Text.Trim()) + @"', '" + strFileName + @"', " + strInactivFlag + ")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_BUSINESS_NEWS SET NEWS_SOURCE = '" + objGen.gReplaceQuotes(txtSource.Text.Trim()) + @"' , NEWS_CAPTION = '" + objGen.gReplaceQuotes(txtCaption.Text.Trim()) + @"' , NEWS_DATE = '" + strNewDate + @"' , NEWS_VALIDITY_DATE = " + newsValidityDate + @" , COUNTRY = '" + objGen.gReplaceQuotes(txtCountry.Text.Trim()) + @"' , CITY = '" + objGen.gReplaceQuotes(txtCity.Text.Trim()) + @"' , NEWS_DESCRIPTION = '" + objGen.gReplaceQuotes(txtNewsDetails.Text.Trim()) + @"' , ATTACHMENT = '" + strFileName + @"' , INACTIVE_FLAG =" + strInactivFlag + @" WHERE NEWS_ID =" + Convert.ToString(ViewState["NEWS_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecords(enmSaveType enType) { try { switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_GLOSSARY (QUESTION ,ANSWER) VALUES ('" + objGen.gReplaceQuotes(txtTerms.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_GLOSSARY SET QUESTION = '" + objGen.gReplaceQuotes(txtTerms.Text.Trim()) + @"' , ANSWER = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' WHERE ID =" + Convert.ToString(ViewState["ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveScaledown(enmSaveType enType) { string strOrder = "0"; if (string.IsNullOrWhiteSpace(txtScaledownSortOrder.Text)) strOrder = "0"; else strOrder = txtScaledownSortOrder.Text; switch (enType) { case enmSaveType.Insert: //Commented by shiv Shankar Hemant on 21.11.2013 // strSql = @"INSERT INTO [INSTA_MST_SOLUTION_SCALEDOWN] // ([SOLUTION_ID] // ,[SCALEDOWN_SOLUTION_ID] // ,[SORT_ORDER] // ,[USER_ID]) // VALUES // (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ," + ddlSolution.SelectedValue + @" // ," + strOrder + @" // ,0)"; // Modify by shiv shankar hemant on 21.11.2013 strSql = @"INSERT INTO [INSTA_MST_SOLUTION_SCALEDOWN] ([SOLUTION_ID] ,[SCALEDOWN_SOLUTION_ID] ,[SORT_ORDER] ,[USER_ID]) VALUES (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ," + ddlSolution.SelectedValue + @" ," + strOrder + @" ," + Convert.ToString(Session["USER_ID"]) + ")"; break; case enmSaveType.Update: //Commented by Shiv Shankar Hemnat on 21.11.2013 // strSql = @"UPDATE [INSTA_MST_SOLUTION_SCALEDOWN] // SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,[SCALEDOWN_SOLUTION_ID] = " + ddlSolution.SelectedValue + @" // ,[SORT_ORDER] =" + strOrder + @" // ,[USER_ID] = 0 // WHERE [SOLUTION_SCALEDOWN_ID] = " + Convert.ToString(ViewState["SOLUTION_SCALEDOWN_ID"]); // MOdify by Shiv Shankar Hemnat on 21.11.2013 strSql = @"UPDATE [INSTA_MST_SOLUTION_SCALEDOWN] SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,[SCALEDOWN_SOLUTION_ID] = " + ddlSolution.SelectedValue + @" ,[SORT_ORDER] =" + strOrder + @" ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" WHERE [SOLUTION_SCALEDOWN_ID] = " + Convert.ToString(ViewState["SOLUTION_SCALEDOWN_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_SOLUTION_SCALEDOWN] WHERE [SOLUTION_SCALEDOWN_ID] = " + Convert.ToString(ViewState["SOLUTION_SCALEDOWN_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveSolutionDetails(enmSaveType enType) { switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO [INSTA_MST_SOLUTION_DETAILS] ([SOLUTION_ID] ,[PARAGRAPH_HEADER_ID] ,[SOLUTION_DETAILS]) VALUES (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ," + Convert.ToString(ViewState["PARAGRAPH_HEADER_ID"]) + @" ,'" + objGen.gReplaceQuotes(txtSolutionsDetails.Text) + "')"; break; case enmSaveType.Update: strSql = @"UPDATE [INSTA_MST_SOLUTION_DETAILS] SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,[PARAGRAPH_HEADER_ID] = " + Convert.ToString(ViewState["PARAGRAPH_HEADER_ID"]) + @" ,[SOLUTION_DETAILS] = '" + objGen.gReplaceQuotes(txtSolutionsDetails.Text) + @"' WHERE [SOLUTION_DETAIL_ID] =" + Convert.ToString(ViewState["SOLUTION_DETAIL_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_SOLUTION_DETAILS] WHERE [SOLUTION_DETAIL_ID] =" + Convert.ToString(ViewState["SOLUTION_DETAIL_ID"]); break; } //-------------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; }
private bool SaveTradeShow(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- //Take Date from Client //--------------------------------------------------------------------------- string strStartDate = "NULL"; string strEndDate = "NULL"; if (!string.IsNullOrEmpty(txtStartDate.Text)) strStartDate = "'" + txtStartDate.Text.Substring(6, 4) + "-" + txtStartDate.Text.Substring(3, 2) + "-" + txtStartDate.Text.Substring(0, 2) + "'"; if (!string.IsNullOrEmpty(txtEndDate.Text)) strEndDate = "'" + txtEndDate.Text.Substring(6, 4) + "-" + txtEndDate.Text.Substring(3, 2) + "-" + txtEndDate.Text.Substring(0, 2) + "'"; //-------------------------------------------------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_TRADE_SHOW (TRADE_SHOW_NAME, TRADE_SHOW_START_DATE, TRADE_SHOW_END_DATE, TRADE_SHOW_CITY, TRADE_SHOW_COUNTRY, SORT_ORDER, USER_ID, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"', " + strStartDate + @", " + strEndDate + @", '" + objGen.gReplaceQuotes(txtCity.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtCountry.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', " + Convert.ToString(Session["USER_ID"]) + @", '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_TRADE_SHOW SET TRADE_SHOW_NAME = '" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"' , TRADE_SHOW_START_DATE = " + strStartDate + @", TRADE_SHOW_END_DATE = " + strEndDate + @" , TRADE_SHOW_CITY = '" + objGen.gReplaceQuotes(txtCity.Text.Trim()) + @"' , TRADE_SHOW_COUNTRY = '" + objGen.gReplaceQuotes(txtCountry.Text.Trim()) + @"' , SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"' , USER_ID = " + Convert.ToString(Session["USER_ID"]) + @", INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE TRADE_SHOW_ID =" + Convert.ToString(ViewState["TRADE_SHOW_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveFileAttchment(enmSaveType enType) { UploadAttachmentFiles(); //--------------------------------------------- string strOrder = "0"; if (string.IsNullOrWhiteSpace(txtAttachFileSort.Text)) strOrder = "0"; else strOrder = txtAttachFileSort.Text; switch (enType) { case enmSaveType.Insert: //Commented by Shiv Shankar Hmeant on 21.11.2013 // strSql = @"INSERT INTO [INSTA_MST_SOLUTION_ATTACHMENT] // ([SOLUTION_ID] // ,[ATTACHMENT_DESCRIPTION] // ,[ATTACHMENT_FILENAME] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,'" + objGen.gReplaceQuotes(txtAttachFileDescription.Text) + @"' // ,'" + Convert.ToString(ViewState["AttachFileName"]) + @"' // ," + strOrder + @" // ,0 // ," + ddlAttachFileStatus.SelectedValue + ")"; //Modify by Shiv Shankar Hemnat on 21.11.2013 strSql = @"INSERT INTO [INSTA_MST_SOLUTION_ATTACHMENT] ([SOLUTION_ID] ,[ATTACHMENT_DESCRIPTION] ,[ATTACHMENT_FILENAME] ,[SORT_ORDER] ,[USER_ID] ,[INACTIVE_FLAG]) VALUES (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,'" + objGen.gReplaceQuotes(txtAttachFileDescription.Text) + @"' ,'" + Convert.ToString(ViewState["AttachFileName"]) + @"' ," + strOrder + @" ," + Convert.ToString(Session["USER_ID"]) + @" ," + ddlAttachFileStatus.SelectedValue + ")"; break; case enmSaveType.Update: //Commented by shiv Shankar Hemnat on 21.11.2013 // strSql = @"UPDATE [INSTA_MST_SOLUTION_ATTACHMENT] // SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,[ATTACHMENT_FILENAME] ='" + Convert.ToString(ViewState["AttachFileName"]) + @"' // ,[ATTACHMENT_DESCRIPTION] = '" + objGen.gReplaceQuotes(txtAttachFileDescription.Text) + @"' // ,[SORT_ORDER] =" + strOrder + @" // ,[USER_ID] = 0 // ,[INACTIVE_FLAG] = " + ddlAttachFileStatus.SelectedValue + @" // WHERE [SOLUTION_ATTACHMENT_ID] = " + Convert.ToString(ViewState["SOLUTION_ATTACHMENT_ID"]); //Modify by Shiv Shankar Hmenat on 21.11.2013 strSql = @"UPDATE [INSTA_MST_SOLUTION_ATTACHMENT] SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,[ATTACHMENT_FILENAME] = '" + Convert.ToString(ViewState["AttachFileName"]) + @"' ,[ATTACHMENT_DESCRIPTION] = '" + objGen.gReplaceQuotes(txtAttachFileDescription.Text) + @"' ,[SORT_ORDER] = " + strOrder + @" ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" ,[INACTIVE_FLAG] = " + ddlAttachFileStatus.SelectedValue + @" WHERE [SOLUTION_ATTACHMENT_ID] = " + Convert.ToString(ViewState["SOLUTION_ATTACHMENT_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_SOLUTION_ATTACHMENT] WHERE [SOLUTION_ATTACHMENT_ID] = " + Convert.ToString(ViewState["SOLUTION_ATTACHMENT_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveRecords(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_FAQ (QUESTION ,ANSWER ,FAQ_CATEGORY_ID ,SORT_ORDER ,INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtQuestion.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtAnswer.Text.Trim()) + @"', "+ ddlCategory.SelectedValue +@", " + txtDisplayOrder.Text.Trim() + @", " + strInactivFlag +")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_FAQ SET QUESTION = '" + objGen.gReplaceQuotes(txtQuestion.Text.Trim()) + @"' , ANSWER = '" + objGen.gReplaceQuotes(txtAnswer.Text.Trim()) + @"', FAQ_CATEGORY_ID = " + ddlCategory.SelectedValue + @", SORT_ORDER = '" + objGen.gReplaceQuotes(txtDisplayOrder.Text.Trim()) + @"', INACTIVE_FLAG = " + strInactivFlag + @" WHERE FAQ_ID =" + Convert.ToString(ViewState["FAQ_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecord(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_CASE_CATEGORY (CASE_CATEGORY_NAME ,CASE_CATEGORY_DESCRIPTION ,CASE_CATEGORY_BANNER_TOP ,SORT_ORDER ,INACTIVE_FLAG ,CREATE_USER_ID) VALUES ('" + objGen.gReplaceQuotes(txtCategoryName.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtCategoryDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtCategoryBannerTop.Text.Trim()) + @", " + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @", "+ strInactivFlag + @" " + Convert.ToString( Session["USER_ID"]) + ")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_CASE_CATEGORY SET CASE_CATEGORY_NAME = '" + objGen.gReplaceQuotes(txtCategoryName.Text.Trim()) + @"' , CASE_CATEGORY_DESCRIPTION = '" + objGen.gReplaceQuotes(txtCategoryDescription.Text.Trim()) + @"' , CASE_CATEGORY_BANNER_TOP = '" + objGen.gReplaceQuotes(txtCategoryBannerTop.Text.Trim()) + @"' , SORT_ORDER = " + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @" , CREATE_USER_ID =" + Convert.ToString(Session["USER_ID"]) + @", INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE CASE_CATEGORY_ID = " + Convert.ToString(ViewState["CASE_CATEGORY_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecords(enmSaveType enType) { bool bnlStatus = true; try { string strInactivFlag = "0"; //------------------------------------------- //if (chkInactivFlag.Checked) strInactivFlag = "1"; Int32 intNewsId = 0; int intIndex = 0; //------------------------------------------- switch (enType) { case enmSaveType.Insert: List<string> strImageName = new List<string>(); HttpFileCollection uploadedFiles = Request.Files; int i = uploadedFiles.Count; if (i > 0) { for (int j = 0; j < i; j++) { HttpPostedFile userPostedFile = uploadedFiles[j]; if (userPostedFile.FileName != "") { userPostedFile.SaveAs(Server.MapPath("~/upload" + "\\Newsletter\\" + Path.GetFileName(userPostedFile.FileName))); strImageName.Add(userPostedFile.FileName); } } } //------------------------------------------------------------------------------------------------------------------------ strSql = @"INSERT INTO INSTA_NEWS_MST_NEWS (MONTH_ID ,SECTION_ID ,NEWS_HEADER ,NEWS_DETAIL ,SECTION_UNDER_IMAGES ,NEWS_SORT_ORDER) VALUES (" + Convert.ToString(ViewState["MONTH_ID"]) + @", " + ddlSection.SelectedValue + @", '" + objGen.gReplaceQuotes(txtNewsHeader.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtNewsDetails.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtSectionUnderImage.Text.Trim()) + @"', " + txtSortingOrder.Text + ")"; objHelper.gTransactionHandler(DBHelper.TransactionType.Open); if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) > 0) { strSql = " SELECT SCOPE_IDENTITY() AS NEWS_ID"; intNewsId = Convert.ToInt32(objHelper.gExecuteScalar(true, CommandType.Text, strSql)); if (strImageName.Count > 0) { strSql = @"INSERT INTO INSTA_NEWS_MST_PICTURE (NEWS_ID ,PICTURE_DESCRIPTION ,PICTURE_SORT_ORDER)"; int intCounter = 1; foreach (string strImagename in strImageName) { strSql += " SELECT " + intNewsId + ",'" + objGen.gReplaceQuotes(strImagename) + "'," + intCounter; if (intIndex < strImageName.Count - 1) strSql += " UNION "; intCounter++; intIndex++; } objHelper.gExecuteNonQuery(true, CommandType.Text, strSql); } objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); bnlStatus = true; } break; case enmSaveType.Update: strSql = @"UPDATE INSTA_NEWS_MST_NEWS SET SECTION_ID = " + ddlSection.SelectedValue + @", NEWS_HEADER = '" + objGen.gReplaceQuotes(txtNewsHeader.Text.Trim()) + @"', NEWS_DETAIL = '" + objGen.gReplaceQuotes(txtNewsDetails.Text.Trim()) + @"', SECTION_UNDER_IMAGES ='" + objGen.gReplaceQuotes(txtSectionUnderImage.Text.Trim()) + @"', NEWS_SORT_ORDER = " + txtSortingOrder.Text + @" WHERE NEWS_ID =" + Convert.ToString(ViewState["NEWS_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) bnlStatus = true; break; case enmSaveType.Delete: objHelper.gTransactionHandler(DBHelper.TransactionType.Open); strSql = @"DELETE FROM INSTA_NEWS_MST_PICTURE WHERE NEWS_ID =" + Convert.ToString(ViewState["NEWS_ID"]); objHelper.gExecuteNonQuery(true, CommandType.Text, strSql); strSql = @"DELETE FROM INSTA_NEWS_MST_NEWS WHERE NEWS_ID =" + Convert.ToString(ViewState["NEWS_ID"]); if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) > 0) { objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); bnlStatus = true; } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); bnlStatus = false; } break; case enmSaveType.ImageInsert: if (fuImage.HasFile) objGen.gUploadFiles("~/upload/Newsletter/", fuImage, this); strSql = @"INSERT INTO INSTA_NEWS_MST_PICTURE (NEWS_ID ,PICTURE_DESCRIPTION ,PICTURE_SORT_ORDER) VALUES (" + Convert.ToString(ViewState["NEWS_ID"]) + @" ,'" + objGen.gReplaceQuotes(fuImage.FileName) + @"' ," + txtImageOrder.Text + ")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) bnlStatus = true; break; case enmSaveType.ImageUpdate: string strFileName = ""; if (fuImage.HasFile) { objGen.gUploadFiles("~/upload/Newsletter/", fuImage, this); strFileName = fuImage.FileName; } else { strFileName = txtImageName.Text; } strSql = @"UPDATE INSTA_NEWS_MST_PICTURE SET PICTURE_DESCRIPTION = '" + objGen.gReplaceQuotes(strFileName) + @"', PICTURE_SORT_ORDER = " + txtImageOrder.Text + @" WHERE PICTURE_ID =" + Convert.ToString(ViewState["PICTURE_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) bnlStatus = true; break; case enmSaveType.ImageDelete: strSql = @"DELETE FROM INSTA_NEWS_MST_PICTURE WHERE PICTURE_ID =" + Convert.ToString(ViewState["PICTURE_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) bnlStatus = true; break; } } catch (Exception err) { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); lblErrorMessage.Text = err.Message; divError.Visible = true; bnlStatus = false; } return bnlStatus; }
private bool SaveCurrency(enmSaveType enType) { try { switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_CURRENCY (CURRENCY_DESCRIPTION, CURRENCY_SYMBOL) VALUES ('" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtSymbol.Text.Trim()) + @"')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_CURRENCY SET CURRENCY_DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , CURRENCY_SYMBOL = '" + objGen.gReplaceQuotes(txtSymbol.Text.Trim()) + @"' WHERE CURRENCY_ID = " + Convert.ToString(ViewState["CURRENCY_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecords(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_FAQ_CATEGORY (FAQ_CATEGORY_DESCRIPTION ,SORT_ORDER) VALUES ('" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDisplayOrder.Text.Trim()) + @"')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_FAQ_CATEGORY SET FAQ_CATEGORY_DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , SORT_ORDER = '" + objGen.gReplaceQuotes(txtDisplayOrder.Text.Trim()) + @"' WHERE FAQ_CATEGORY_ID =" + Convert.ToString(ViewState["FAQ_CATEGORY_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveSize(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; double dblTotalArea = Math.Round(Convert.ToDouble(txtLength.Text) * Convert.ToDouble(txtBreadth.Text),2,MidpointRounding.AwayFromZero); //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_SIZE (SIZE_DESCRIPTION, LENGTH, BREADTH, TOTAL_AREA, SORT_ORDER, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtSizeDescription.Text.Trim()) + @"', " + txtLength.Text +@", " + txtBreadth.Text+@", " + dblTotalArea + @", '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_SIZE SET SIZE_DESCRIPTION = '" + objGen.gReplaceQuotes(txtSizeDescription.Text.Trim()) + @"' , LENGTH = " + txtLength.Text.Trim() + @" , BREADTH = " + txtBreadth.Text.Trim() + @" , TOTAL_AREA = " + dblTotalArea + @", SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"' , INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE SIZE_ID =" + Convert.ToString(ViewState["SIZE_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveNewsRecords(enmSaveType enType) { try { string strAttachment = ""; string strImage1 = ""; string strImage2 = ""; string strNewsDate = ""; string strNewsValidity = ""; //-------------------------------------------------------------------- if (!string.IsNullOrWhiteSpace(txtNewsDate.Text)) strNewsDate = txtNewsDate.Text.Substring(6, 4) + "-" + txtNewsDate.Text.Substring(3, 2) + "-" + txtNewsDate.Text.Substring(0, 2); //-------------------------------------------------------------------- if (!string.IsNullOrWhiteSpace(txtNewsValidity.Text)) strNewsValidity = txtNewsValidity.Text.Substring(6, 4) + "-" + txtNewsValidity.Text.Substring(3, 2) + "-" + txtNewsValidity.Text.Substring(0, 2); //------------------------------------------------------------------- if (fuFileAttachment.HasFile) strAttachment = fuFileAttachment.FileName; else strAttachment = objGen.gReplaceQuotes(txtFileAttachment.Text); //------------------------------------------------------------------- if (fuImage1.HasFile) strImage1 = fuImage1.FileName; else strImage1 = objGen.gReplaceQuotes(txtImage1.Text); //------------------------------------------------------------------- if (fuImage2.HasFile) strImage2 = fuImage2.FileName; else strImage2 = objGen.gReplaceQuotes(txtImage2.Text); //------------------------------------------------------------------ switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO [INSTA_MST_NEWS] ([NEWS_CAPTION] ,[NEWS_DATE] ,[NEWS_VALIDITY] ,[ATTACH_FILE] ,[IMAGE1] ,[IMAGE2] ,[ALT_TEXT1] ,[ALT_TEXT2] ,[NEWS_DESC]) VALUES ('" + objGen.gReplaceQuotes(txtNewsHeadlines.Text) + @"' ,'" + strNewsDate + @"' ,'" + strNewsValidity + @"' ,'" + strAttachment + @"' ,'" + strImage1 + @"' ,'" + strImage2 + @"' ,'" + objGen.gReplaceQuotes(txtAlternateText1.Text) + @"' ,'" + objGen.gReplaceQuotes(txtAlternateText2.Text) + @"' ,'" + objGen.gReplaceQuotes(ckNewsDesc.Text) + @"')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { if (fuFileAttachment.HasFile) objGen.gUploadFiles(strFileAttachment, fuFileAttachment, this); if (fuImage1.HasFile) objGen.gUploadFiles(strImageFilePath, fuImage1, this); if (fuImage2.HasFile) objGen.gUploadFiles(strImageFilePath, fuImage2, this); return true; } else return false; case enmSaveType.Update: strSql = @"UPDATE [INSTA_MST_NEWS] SET [NEWS_CAPTION] = '" + objGen.gReplaceQuotes(txtNewsHeadlines.Text) + @"' ,[NEWS_DATE] = '" + strNewsDate + @"' ,[NEWS_VALIDITY] = '" + strNewsValidity + @"' ,[ATTACH_FILE] = '" + strAttachment + @"' ,[IMAGE1] = '" + strImage1 + @"' ,[IMAGE2] = '" + strImage2 + @"' ,[ALT_TEXT1] = '" + objGen.gReplaceQuotes(txtAlternateText1.Text) + @"' ,[ALT_TEXT2] = '" + objGen.gReplaceQuotes(txtAlternateText2.Text) + @"' ,[NEWS_DESC] = '" + objGen.gReplaceQuotes(ckNewsDesc.Text) + @"' WHERE [NEWS_ID] = " + Convert.ToString(ViewState["NEWS_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { if (fuFileAttachment.HasFile) objGen.gUploadFiles(strFileAttachment, fuFileAttachment, this); if (fuImage1.HasFile) objGen.gUploadFiles(strImageFilePath, fuImage1, this); if (fuImage2.HasFile) objGen.gUploadFiles(strImageFilePath, fuImage2, this); return true; } else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveParagraph(enmSaveType enType) { try { string strInactivFlag = "0"; string strBulletFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; if (chkBulletFlag.Checked) strBulletFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_PARAGRAPH_HEADER (PARAGRAPH_DESCRIPTION, SORT_ORDER, DEFAULT_LINES, BULLET_FLAG, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtParagraph.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtSortOrder.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDefaultLines.Text.Trim()) + @"', '" + strBulletFlag + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_PARAGRAPH_HEADER SET PARAGRAPH_DESCRIPTION = '" + objGen.gReplaceQuotes(txtParagraph.Text.Trim()) + @"' , SORT_ORDER = '" + objGen.gReplaceQuotes(txtSortOrder.Text.Trim()) + @"' , DEFAULT_LINES ='" + objGen.gReplaceQuotes(txtDefaultLines.Text.Trim()) + @"' , BULLET_FLAG='" + strBulletFlag + @"' , INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE PARAGRAPH_HEADER_ID = " + Convert.ToString(ViewState["PARAGRAPH_HEADER_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecords(enmSaveType enType) { try { string strInactivFlag = "0"; string strNewDate = ""; string newsValidityDate =""; string strFileName = ""; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //UPLOAD ATTACHMENT FILE TO SERVER if (fuAttachment.HasFile) { strFileName = fuAttachment.FileName; objGen.gUploadFiles(strUploadAttachmentPath, fuAttachment, this); } else strFileName = objGen.gReplaceQuotes(txtAttachmentFile.Text); //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_TESTIMONIAL (COMPANY ,PERSON ,DESIGNATION ,INDUSTRY_SEGMENT_ID ,DESCRIPTION ,LOGO_ATTACHMENT ,INACTIVE_FLAG) VALUES('" + objGen.gReplaceQuotes(txtCompany.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtPerson.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDesignation.Text.Trim()) + @"', " + ddlIndustry.SelectedValue + @", '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + strFileName + @"', " + strInactivFlag + ")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_TESTIMONIAL SET COMPANY = '" + objGen.gReplaceQuotes(txtCompany.Text.Trim()) + @"' , PERSON = '" + objGen.gReplaceQuotes(txtPerson.Text.Trim()) + @"' , DESIGNATION = '" + objGen.gReplaceQuotes(txtDesignation.Text.Trim()) + @"' , INDUSTRY_SEGMENT_ID = " + ddlIndustry.SelectedValue + @", DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , LOGO_ATTACHMENT = '" + strFileName + @"' , INACTIVE_FLAG =" + strInactivFlag + @" WHERE TESTIMONIAL_ID =" + Convert.ToString(ViewState["TESTIMONIAL_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRegion(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_REGION (REGION_NAME, SORT_ORDER, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtRegion.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_REGION SET REGION_NAME = '" + objGen.gReplaceQuotes(txtRegion.Text.Trim()) + @"' , SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"' , INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE REGION_ID = " + Convert.ToString(ViewState["REGION_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveRecords(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_NEWS_MST_MONTHYEAR (MONTH_CODE ,YEAR_CODE ,DESCRIPTION ,INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtMonth.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtYear.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', " + strInactivFlag + ")"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_NEWS_MST_MONTHYEAR SET MONTH_CODE = '" + objGen.gReplaceQuotes(txtMonth.Text.Trim()) + @"' , YEAR_CODE = '" + objGen.gReplaceQuotes(txtYear.Text.Trim()) + @"' , DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , INACTIVE_FLAG =" + strInactivFlag + @" WHERE MONTH_ID =" + Convert.ToString(ViewState["MONTH_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveClients(enmSaveType enType) { string strDate = ""; string strActiveInactive = "0"; string strTradeShow = "0"; string strProduct = "0"; if (chkActiveInactive.Checked) strActiveInactive = "1"; UploadImagesFiles(); //--------------------------------------------------- // Modified by Ripan Paul on 21-10-2013 as per SB if (!string.IsNullOrEmpty(txtDateOfDisplay.Text.Trim())) // Commented by Shiv Shanakr Hemant on 04-JUN-2014 // strDate = "'" + txtDateOfDisplay.Text.Substring(6, 4) + "-" + txtDateOfDisplay.Text.Substring(3, 2) + "-" + txtDateOfDisplay.Text.Substring(0, 2) + "'"; { string date = txtDateOfDisplay.Text; // Modify by Shiv Shankar Hemant on 04-JUN-2014 strDate = "'" + txtDateOfDisplay.Text.Substring(0, 2) + "/" + txtDateOfDisplay.Text.Substring(3, 4) + "'"; } else strDate = "''"; //--------------------------------------------------- if (ddlTradeShow.SelectedIndex > 0) strTradeShow = ddlTradeShow.SelectedValue; if (ddlProduct.SelectedIndex > 0) strProduct = ddlProduct.SelectedValue; switch (enType) { case enmSaveType.Insert: // Commented by Ripan Paul on 21-10-2013 as per SB // strSql = @"INSERT INTO [INSTA_MST_CLIENT] // ([CLIENT_NAME] // ,[DISPLAY_DATE] // ,[CLIENT_IMAGE_BIG] // ,[CLIENT_IMAGE_THUMBNAIL] // ,[CLIENT_BRIEF_NOTE] // ,[INDUSTRY_SEGMENT_ID] // ,[SHOW_FORMAT_ID] // ,[REGION_ID] // ,[TRADE_SHOW_ID] // ,[CLIENT_VIDEO_LINK] // ,[CLIENT_TESTIMONIAL_TEXT] // ,[CLIENT_TESTIMONIAL_LINK] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // ('" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // ,'" + strDate + @"' // ,'" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,'" + Convert.ToString(ViewState["ThumbImageName"]) + @"' // ,'" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ," + ddlIndustrySegment.SelectedValue + @" // ," + ddlShowFormat.SelectedValue + @" // ," + ddlRegion.SelectedValue + @" // ," + strTradeShow + @" // ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ," + txtSortOrder.Text + @" // ,0 // ," + strActiveInactive + ")"; //Commented by Shiv Shankar Hemnat on 21.11.2013 // Modified by Ripan Paul on 21-10-2013 as per SB // strSql = @"INSERT INTO [INSTA_MST_CLIENT] // ([CLIENT_NAME] // ,[DISPLAY_DATE] // ,[CLIENT_IMAGE_BIG] // ,[CLIENT_IMAGE_THUMBNAIL] // ,[CLIENT_BRIEF_NOTE] // ,[INDUSTRY_SEGMENT_ID] // ,[SHOW_FORMAT_ID] // ,[REGION_ID] // ,[TRADE_SHOW_ID] // ,[CLIENT_VIDEO_LINK] // ,[CLIENT_TESTIMONIAL_TEXT] // ,[CLIENT_TESTIMONIAL_LINK] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // ('" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // , " + strDate + @" // ,'" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,'' // ,'" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ," + ddlIndustrySegment.SelectedValue + @" // ," + ddlShowFormat.SelectedValue + @" // ," + ddlRegion.SelectedValue + @" // ," + strTradeShow + @" // ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ," + txtSortOrder.Text + @" // ,0 // ," + strActiveInactive + ")"; // Commented by Shiv shankar Hemant on 04-JUN-2014 //Modify by Shiv Shankar hemnat on 21.11.2013 // strSql = @"INSERT INTO [INSTA_MST_CLIENT] // ([CLIENT_NAME] // ,[DISPLAY_DATE] // ,[CLIENT_IMAGE_BIG] // ,[CLIENT_IMAGE_THUMBNAIL] // ,[CLIENT_BRIEF_NOTE] // ,[INDUSTRY_SEGMENT_ID] // ,[SHOW_FORMAT_ID] // ,[REGION_ID] // ,[TRADE_SHOW_ID] // ,[CLIENT_VIDEO_LINK] // ,[CLIENT_TESTIMONIAL_TEXT] // ,[CLIENT_TESTIMONIAL_LINK] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // ('" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // , " + strDate + @" // ,'" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,'' // ,'" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ," + ddlIndustrySegment.SelectedValue + @" // ," + ddlShowFormat.SelectedValue + @" // ," + ddlRegion.SelectedValue + @" // ," + strTradeShow + @" // ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ," + txtSortOrder.Text + @" // ," + Convert.ToString(Session["USER_ID"]) + @" // ," + strActiveInactive + ")"; //Commented by Shrey Kejriwal on 16-11-2015 // Modify By Shiv Shankar Hemant on 04-JUN-2014 // strSql = @"INSERT INTO [INSTA_MST_CLIENT] // ([CLIENT_NAME] // ,[DISPLAY_MONTH] // ,[BOOTH_SIZE] // ,[CLIENT_IMAGE_BIG] // ,[CLIENT_IMAGE_THUMBNAIL] // ,[CLIENT_BRIEF_NOTE] // ,[INDUSTRY_SEGMENT_ID] // ,[SHOW_FORMAT_ID] // ,[REGION_ID] // ,[TRADE_SHOW_ID] // ,[PRODUCT_ID] // ,[CLIENT_VIDEO_LINK] // ,[CLIENT_TESTIMONIAL_TEXT] // ,[CLIENT_TESTIMONIAL_LINK] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // ('" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // , " + strDate + @" // , '" + txtBoothSize.Text + @"' // ,'" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,'' // ,'" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ," + ddlIndustrySegment.SelectedValue + @" // ," + ddlShowFormat.SelectedValue + @" // ," + ddlRegion.SelectedValue + @" // ," + strTradeShow + @" // ," + strProduct +@" // ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ," + txtSortOrder.Text + @" // ," + Convert.ToString(Session["USER_ID"]) + @" // ," + strActiveInactive + ")"; //Added by Shrey Kejriwal on 16-11-2015 strSql = @"INSERT INTO [INSTA_MST_CLIENT] ([CLIENT_NAME] ,[DISPLAY_MONTH] ,[BOOTH_SIZE] ,[CLIENT_IMAGE_BIG] ,[CLIENT_IMAGE_THUMBNAIL] ,[CLIENT_BRIEF_NOTE] ,[INDUSTRY_SEGMENT_ID] ,[SHOW_FORMAT_ID] ,[REGION_ID] ,[TRADE_SHOW_ID] ,[PRODUCT_ID] ,[CLIENT_VIDEO_LINK] ,[CLIENT_TESTIMONIAL_TEXT] ,[CLIENT_TESTIMONIAL_LINK] ,[SORT_ORDER] ,[USER_ID] ,[URL], ,[PAGE_TITLE], ,[DESCRIPTION_TEXT], ,[PAGE_DESC], ,[PAGE_KEYWORDS]) VALUES ('" + objGen.gReplaceQuotes(txtClientName.Text) + @"' , " + strDate + @" , '" + txtBoothSize.Text + @"' ,'" + Convert.ToString(ViewState["BigImageName"]) + @"' ,'' ,'" + objGen.gReplaceQuotes(txtNotes.Text) + @"' ," + ddlIndustrySegment.SelectedValue + @" ," + ddlShowFormat.SelectedValue + @" ," + ddlRegion.SelectedValue + @" ," + strTradeShow + @" ," + strProduct + @" ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' ,'" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' ,'" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' ," + txtSortOrder.Text + @" ," + Convert.ToString(Session["USER_ID"]) + @" ," + strActiveInactive + @" ,'" + objGen.gReplaceQuotes(txtURL.Text) + @"' ,'" + objGen.gReplaceQuotes(txtPageTitle.Text) + @"' ,'" + objGen.gReplaceQuotes(txtPageDesc.Text) + @"' ,'" + objGen.gReplaceQuotes(txtMetaDesc.Text) + @"' ,'" + objGen.gReplaceQuotes(txtMetaKeywords.Text) + @"')"; break; case enmSaveType.Update: // Commented by Ripan Paul on 21-10-2013 as per SB // strSql = @"UPDATE [INSTA_MST_CLIENT] // SET [CLIENT_NAME] = '" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // ,[DISPLAY_DATE] = '" + strDate + @"' // ,[CLIENT_IMAGE_BIG] = '" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,[CLIENT_IMAGE_THUMBNAIL] = '" + Convert.ToString(ViewState["ThumbImageName"]) + @"' // ,[CLIENT_BRIEF_NOTE] = '" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ,[INDUSTRY_SEGMENT_ID] = " + ddlIndustrySegment.SelectedValue + @" // ,[SHOW_FORMAT_ID] = " + ddlShowFormat.SelectedValue + @" // ,[REGION_ID] = " + ddlRegion.SelectedValue + @" // ,[TRADE_SHOW_ID] = " + strTradeShow + @" // ,[CLIENT_VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,[CLIENT_TESTIMONIAL_TEXT] ='" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,[CLIENT_TESTIMONIAL_LINK] = '" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ,[SORT_ORDER] = " + txtSortOrder.Text + @" // ,[USER_ID] = 0 // ,[INACTIVE_FLAG] = " + strActiveInactive + @" // WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); //Commented by Shiv Shankar Hemnat on 21.11.2013 // Modified by Ripan Paul on 21-10-2013 as per SB // strSql = @"UPDATE [INSTA_MST_CLIENT] // SET [CLIENT_NAME] = '" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // ,[DISPLAY_DATE] = " + strDate + @" // ,[CLIENT_IMAGE_BIG] = '" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,[CLIENT_BRIEF_NOTE] = '" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ,[INDUSTRY_SEGMENT_ID] = " + ddlIndustrySegment.SelectedValue + @" // ,[SHOW_FORMAT_ID] = " + ddlShowFormat.SelectedValue + @" // ,[REGION_ID] = " + ddlRegion.SelectedValue + @" // ,[TRADE_SHOW_ID] = " + strTradeShow + @" // ,[CLIENT_VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,[CLIENT_TESTIMONIAL_TEXT] ='" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,[CLIENT_TESTIMONIAL_LINK] = '" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ,[SORT_ORDER] = " + txtSortOrder.Text + @" // ,[USER_ID] = 0 // ,[INACTIVE_FLAG] = " + strActiveInactive + @" // WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); // Commanted by Shiv shankar Hemant on 04-JUB-2014 //Modify by Shiv Shankar Hemnat on 21.11.2013 // strSql = @"UPDATE [INSTA_MST_CLIENT] // SET [CLIENT_NAME] = '" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // ,[DISPLAY_DATE] = " + strDate + @" // ,[CLIENT_IMAGE_BIG] = '" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,[CLIENT_BRIEF_NOTE] = '" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ,[INDUSTRY_SEGMENT_ID] = " + ddlIndustrySegment.SelectedValue + @" // ,[SHOW_FORMAT_ID] = " + ddlShowFormat.SelectedValue + @" // ,[REGION_ID] = " + ddlRegion.SelectedValue + @" // ,[TRADE_SHOW_ID] = " + strTradeShow + @" // ,[CLIENT_VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,[CLIENT_TESTIMONIAL_TEXT] ='" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,[CLIENT_TESTIMONIAL_LINK] = '" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ,[SORT_ORDER] = " + txtSortOrder.Text + @" // ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" // ,[INACTIVE_FLAG] = " + strActiveInactive + @" // WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); //Commented by Shrey Kejriwal on 16-11-2015 // strSql = @"UPDATE [INSTA_MST_CLIENT] // SET [CLIENT_NAME] = '" + objGen.gReplaceQuotes(txtClientName.Text) + @"' // ,[DISPLAY_MONTH] = " + strDate + @" // ,[BOOTH_SIZE] = '" + txtBoothSize.Text + @"' // ,[CLIENT_IMAGE_BIG] = '" + Convert.ToString(ViewState["BigImageName"]) + @"' // ,[CLIENT_BRIEF_NOTE] = '" + objGen.gReplaceQuotes(txtNotes.Text) + @"' // ,[INDUSTRY_SEGMENT_ID] = " + ddlIndustrySegment.SelectedValue + @" // ,[SHOW_FORMAT_ID] = " + ddlShowFormat.SelectedValue + @" // ,[REGION_ID] = " + ddlRegion.SelectedValue + @" // ,[TRADE_SHOW_ID] = " + strTradeShow + @" // ,[PRODUCT_ID] = " + strProduct + @" // ,[CLIENT_VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,[CLIENT_TESTIMONIAL_TEXT] ='" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' // ,[CLIENT_TESTIMONIAL_LINK] = '" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' // ,[SORT_ORDER] = " + txtSortOrder.Text + @" // ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" // ,[INACTIVE_FLAG] = " + strActiveInactive + @" // WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); //Added by Shrey Kejriwal on 16-11-2015 strSql = @"UPDATE [INSTA_MST_CLIENT] SET [CLIENT_NAME] = '" + objGen.gReplaceQuotes(txtClientName.Text) + @"' ,[DISPLAY_MONTH] = " + strDate + @" ,[BOOTH_SIZE] = '" + txtBoothSize.Text + @"' ,[CLIENT_IMAGE_BIG] = '" + Convert.ToString(ViewState["BigImageName"]) + @"' ,[CLIENT_BRIEF_NOTE] = '" + objGen.gReplaceQuotes(txtNotes.Text) + @"' ,[INDUSTRY_SEGMENT_ID] = " + ddlIndustrySegment.SelectedValue + @" ,[SHOW_FORMAT_ID] = " + ddlShowFormat.SelectedValue + @" ,[REGION_ID] = " + ddlRegion.SelectedValue + @" ,[TRADE_SHOW_ID] = " + strTradeShow + @" ,[PRODUCT_ID] = " + strProduct + @" ,[CLIENT_VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' ,[CLIENT_TESTIMONIAL_TEXT] ='" + objGen.gReplaceQuotes(txtTestimonial.Text) + @"' ,[CLIENT_TESTIMONIAL_LINK] = '" + objGen.gReplaceQuotes(txtTestimonialLink.Text) + @"' ,[SORT_ORDER] = " + txtSortOrder.Text + @" ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" ,[INACTIVE_FLAG] = " + strActiveInactive + @" ,[URL] = '" + objGen.gReplaceQuotes(txtURL.Text) + @"' ,[PAGE_TITLE] = '" + objGen.gReplaceQuotes(txtPageTitle.Text) + @"' ,[DESCRIPTION_TEXT] = '" + objGen.gReplaceQuotes(txtPageDesc.Text) + @"' ,[PAGE_DESC] = '" + objGen.gReplaceQuotes(txtMetaDesc.Text) + @"' ,[PAGE_KEYWORDS] = '" + objGen.gReplaceQuotes(txtMetaKeywords.Text) + @"' WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_CLIENT] WHERE [CLIENT_ID] = " + Convert.ToString(ViewState["CLIENT_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveProduct(enmSaveType enType) { try { string strInactivFlag = "0"; string strLogoImageName = ""; if (fuLogo.HasFile) strLogoImageName = fuLogo.FileName; else strLogoImageName = objGen.gReplaceQuotes(txtLogoName.Text.Trim()); //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_PRODUCT (PRODUCT_NAME, PRODUCT_DESCRIPTION, PRODUCT_FEATURE, PRODUCT_LOGO_NAME, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtProductName.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtFeature.Text.Trim()) + @"', '" + strLogoImageName + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_PRODUCT SET PRODUCT_NAME = '" + objGen.gReplaceQuotes(txtProductName.Text.Trim()) + @"' , PRODUCT_DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , PRODUCT_FEATURE = '" + objGen.gReplaceQuotes(txtFeature.Text.Trim()) + @"' , PRODUCT_LOGO_NAME = '" + strLogoImageName + @"' , INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE PRODUCT_ID =" + Convert.ToString(ViewState["PRODUCT_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { // IMAGE UPLOAD if (fuLogo.HasFile) objGen.gUploadFiles(strImageUploadPathPath, fuLogo, this, fuLogo.FileName); return true; } else return false; } //--------------------------------------------------------------------- } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveExhibitionCenter(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_EXHIBITION_CENTRE( CITY_ID, EXHIBITION_CENTRE_NAME, EXHIBITION_CENTRE_TEXT, EXHIBITION_CENTRE_URL, EXHIBITION_CENTRE_URL_SMALL, EXHIBITION_CENTRE_IMAGE, USER_ID, SORT_ORDER, INACTIVE_FLAG) VALUES( " + objGen.gReplaceQuotes(ddlCity.SelectedValue) + @", '" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtURL.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDisplayURL.Text.Trim()) + @"', '" + Convert.ToString(ViewState["BigImageName"]) + @"', " + Convert.ToString(Session["USER_ID"]) + @", '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_EXHIBITION_CENTRE SET CITY_ID = " + objGen.gReplaceQuotes(ddlCity.SelectedValue) + @", EXHIBITION_CENTRE_NAME = '" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"', EXHIBITION_CENTRE_TEXT = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', EXHIBITION_CENTRE_URL = '" + objGen.gReplaceQuotes(txtURL.Text.Trim()) + @"', EXHIBITION_CENTRE_URL_SMALL = '" + objGen.gReplaceQuotes(txtDisplayURL.Text.Trim()) + @"', EXHIBITION_CENTRE_IMAGE = '" + Convert.ToString(ViewState["BigImageName"]) + @"', USER_ID = " + Convert.ToString(Session["USER_ID"]) + @", SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', INACTIVE_FLAG = '" + strInactivFlag + @"' WHERE EXHIBITION_CENTRE_ID =" + Convert.ToString(ViewState["EXHIBITION_CENTRE_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveExhibitHeader(enmSaveType enType) { try { string strInactivFlag = "0"; //------------------------------------------- if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_EXHIBIT_TYPE_HEADER (EXHIBIT_DESCRIPTION, INACTIVE_FLAG) VALUES ('" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_EXHIBIT_TYPE_HEADER SET EXHIBIT_DESCRIPTION = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"' , INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE EXHIBIT_HEADER_ID = " + Convert.ToString(ViewState["EXHIBIT_HEADER_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveImagesUpload(enmSaveType enType) { UploadImagesFiles(); //--------------------------------------------------- switch (enType) { case enmSaveType.Insert: //Commentd by Shiv Shankar Hemnat on 20.11.2013 // strSql = @"INSERT INTO [INSTA_MST_PICTURE_LINK] // ([SOLUTION_ID] // ,[PICTURE_NAME] // ,[ZOOM_PICTURE_NAME] // ,[PICTURE_TEXT] // ,[LAST_UPLOAD_DATE] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,'" + Convert.ToString(ViewState["ImageName"]) + @"' // ,'" + Convert.ToString(ViewState["ZImageName"]) + @"' // ,'" + objGen.gReplaceQuotes(txtImageText.Text) + @"' // ,getdate() // ," + txtImagesSortOrder.Text + @" // ,0 // ," + ddlImageSortOrderStatus.SelectedValue + ")"; //Modify by Shiv Shankar Hemnat on 20.11.2013 strSql = @"INSERT INTO [INSTA_MST_PICTURE_LINK] ([SOLUTION_ID] ,[PICTURE_NAME] ,[ZOOM_PICTURE_NAME] ,[PICTURE_TEXT] ,[LAST_UPLOAD_DATE] ,[SORT_ORDER] ,[USER_ID] ,[INACTIVE_FLAG]) VALUES (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,'" + Convert.ToString(ViewState["ImageName"]) + @"' ,'" + Convert.ToString(ViewState["ZImageName"]) + @"' ,'" + objGen.gReplaceQuotes(txtImageText.Text) + @"' , SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ," + txtImagesSortOrder.Text + @" , " + Convert.ToString(Session["USER_ID"]) + @" ," + ddlImageSortOrderStatus.SelectedValue + ")"; break; case enmSaveType.Update: //Commented by shiv Shankar Hemant on 20.11.2013 //strSql = @"UPDATE [INSTA_MST_PICTURE_LINK] // SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,[PICTURE_NAME] = '" + Convert.ToString(ViewState["ImageName"]) + @"' // ,[ZOOM_PICTURE_NAME] ='" + Convert.ToString(ViewState["ZImageName"]) + @"' // ,[PICTURE_TEXT] = '" + objGen.gReplaceQuotes(txtImageText.Text) + @"' // ,[LAST_UPLOAD_DATE] = GETDATE() // ,[SORT_ORDER] =" + txtImagesSortOrder.Text + @" // ,[USER_ID] =0 // ,[INACTIVE_FLAG] = " + ddlImageSortOrderStatus.SelectedValue + @" // WHERE [PICTURE_LINK_ID] = " + Convert.ToString(ViewState["PICTURE_LINK_ID"]); // Modify by Shiv shankar Hemnat on 20.11.2013 strSql = @"UPDATE [INSTA_MST_PICTURE_LINK] SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,[PICTURE_NAME] = '" + Convert.ToString(ViewState["ImageName"]) + @"' ,[ZOOM_PICTURE_NAME] ='" + Convert.ToString(ViewState["ZImageName"]) + @"' ,[PICTURE_TEXT] = '" + objGen.gReplaceQuotes(txtImageText.Text) + @"' ,[LAST_UPLOAD_DATE] = SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ,[SORT_ORDER] =" + txtImagesSortOrder.Text + @" ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" ,[INACTIVE_FLAG] = " + ddlImageSortOrderStatus.SelectedValue + @" WHERE [PICTURE_LINK_ID] = " + Convert.ToString(ViewState["PICTURE_LINK_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_PICTURE_LINK] WHERE [PICTURE_LINK_ID] = " + Convert.ToString(ViewState["PICTURE_LINK_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveCaseDetails(enmSaveType enType) { switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO [INSTA_MST_CASE_DETAILS] ([CASE_ID] ,[CASE_SEGMENT_ID] ,[CASE_DETAILS] ,[SORT_ORDER]) VALUES (" + Convert.ToString(ViewState["CASE_ID"]) + @" ," +ddlCaseSegment.SelectedValue + @" ,'" + objGen.gReplaceQuotes(txtCaseDetails.Text) + @"' ," + txtSortOrder.Text + ")"; break; case enmSaveType.Update: strSql = @"UPDATE [INSTA_MST_CASE_DETAILS] SET [CASE_ID] = " + Convert.ToString(ViewState["CASE_ID"]) + @" ,[CASE_SEGMENT_ID] = " + ddlCaseSegment.SelectedValue + @" ,[CASE_DETAILS] = '" + objGen.gReplaceQuotes(txtCaseDetails.Text) + @"' ,[SORT_ORDER] " + txtSortOrder.Text + @" WHERE [CASE_DETAIL_ID] =" + Convert.ToString(ViewState["CASE_DETAIL_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_CASE_DETAILS] WHERE [CASE_DETAIL_ID] =" + Convert.ToString(ViewState["CASE_DETAIL_ID"]); break; } //-------------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; }
private bool SaveSolution(enmSaveType enType) { try { string strDisplayShippingDays = "0"; string strMarkAsLatestProduct = "0"; string strDisplayProductFeature = "0"; string strActiveInactive = "0"; string strIndustrySegments = "0"; string strClientID = "0"; //------------------------------------------- if (chkDisplayShippingDays.Checked) strDisplayShippingDays = "1"; if (chkMarkAsLatestProduct.Checked) strMarkAsLatestProduct = "1"; if (chkDisplayProductFeature.Checked) strDisplayProductFeature = "1"; if (chkActiveInactive.Checked) strActiveInactive = "1"; if (ddlIndustrySegments.SelectedIndex > 0) strIndustrySegments = ddlIndustrySegments.SelectedValue; if (ddlClient.SelectedIndex > 0) strClientID = ddlClient.SelectedValue; //------------------------------------------- switch (enType) { case enmSaveType.Insert: //Commented by shiv Shankar Hemant on 20.11.2013 // strSql = @"INSERT INTO [INSTA_MST_SOLUTION] // ([SOLUTION_NAME] // ,[SIZE_ID] // ,[EXHIBIT_DETAIL_ID] // ,[MOD_PORT_ID] // ,[PRODUCT_ID] // ,[DISCOUNT_ID] // ,[PRICE] // ,[CURRENCY_ID] // ,[SHIPPING_DAYS] // ,[SHIPPING_DISPLAY_FLAG] // ,[CREATE_DATE] // ,[PRODUCT_FEATURE_DISPLAY_FLAG] // ,[SOLUTION_TEXT] // ,[LATEST_FLAG] // ,[INACTIVE_FLAG]) // VALUES // ('" + objGen.gReplaceQuotes(txtName.Text) + @"' // ," + ddlSize.SelectedValue + @" // ," + ddlExhibitDetail.SelectedValue + @" // ," + ddlNature.SelectedValue + @" // ," + ddlProduct.SelectedValue + @" // ," + ddlDiscountRate.Text + @" // ," + txtPrice.Text + @" // ," + ddlCurrency.SelectedValue + @" // ,'" + objGen.gReplaceQuotes(txtShippingDays.Text) + @"' // ," + strDisplayShippingDays + @" // ,GETDATE() // ," + strDisplayProductFeature + @" // ,'" + objGen.gReplaceQuotes(txtDescription.Text) + @"' // ," + strMarkAsLatestProduct + @" // ," + strActiveInactive + ")"; //Modify by Shiv Shankar Hemant on 20.11.2013 strSql = @"INSERT INTO [INSTA_MST_SOLUTION] ([SOLUTION_NAME] ,[DESIGNED_FOR] ,[SIZE_ID] ,[EXHIBIT_DETAIL_ID] ,[MOD_PORT_ID] ,[INDUSTRY_SEGMENT_ID] ,[PRODUCT_ID] ,[CLIENT_ID] ,[DISCOUNT_ID] ,[PRICE] ,[CURRENCY_ID] ,[SHIPPING_DAYS] ,[SHIPPING_DISPLAY_FLAG] ,[CREATE_DATE] ,[PRODUCT_FEATURE_DISPLAY_FLAG] ,[SOLUTION_TEXT] ,[LATEST_FLAG] ,[INACTIVE_FLAG] ,[PRODUCT_FLAG] ,[USER_ID]) VALUES ('" + objGen.gReplaceQuotes(txtName.Text) + @"' ,'" + objGen.gReplaceQuotes(txtDesignFor.Text) + @"' ," + ddlSize.SelectedValue + @" ," + ddlExhibitDetail.SelectedValue + @" ," + ddlNature.SelectedValue + @" ," + strIndustrySegments + @" ," + ddlProduct.SelectedValue + @" ," + strClientID +@" ," + ddlDiscountRate.Text + @" ," + txtPrice.Text + @" ," + ddlCurrency.SelectedValue + @" ,'" + objGen.gReplaceQuotes(txtShippingDays.Text) + @"' ," + strDisplayShippingDays + @" , SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ," + strDisplayProductFeature + @" ,'" + objGen.gReplaceQuotes(txtDescription.Text) + @"' ," + strMarkAsLatestProduct + @" ," + strActiveInactive + @" ,0 , " + Convert.ToString(Session["USER_ID"]) + ")"; //Added by Shiv Shankar Hemant on 08-11-2013 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ objHelper.gTransactionHandler(DBHelper.TransactionType.Open); if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) > 0) { //RETRIVE LAST SOLUTION ID strSql = "SELECT SCOPE_IDENTITY() AS SOLUTION_ID"; string strSol_ID = Convert.ToString(objHelper.gExecuteScalar(true, CommandType.Text, strSql)); if (!string.IsNullOrWhiteSpace(strSol_ID)) { strSql = @" INSERT INTO [INSTA_MST_SOLUTION_APPLICATION] ( SOLUTION_ID, APPLICATION_ID) "; bool isFirstRecord = false; for (int iCounter = 0; iCounter < grdSolutionApplication.Rows.Count; iCounter++) { GridViewRow row = grdSolutionApplication.Rows[iCounter]; if (((CheckBox)row.FindControl("chkSubject")).Checked == true) { if (!isFirstRecord) { strSql += " VALUES( " + strSol_ID + "," + grdSolutionApplication.DataKeys[iCounter].Value.ToString() + " ),"; isFirstRecord = true; } else { strSql += " ( " + strSol_ID + "," + grdSolutionApplication.DataKeys[iCounter].Value.ToString() + " ),"; } } } //CHECK BOX SELECTION IS NOT MANDATORY. if (isFirstRecord) { strSql = strSql.Substring(0, strSql.LastIndexOf(",")); //----------------------------------------------------------------------- if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) > 0) { objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); return true; } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); return false; } } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); return true; } //----------------------------------------------------------------------- } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); return false; } } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ break; case enmSaveType.Update: //Commented by Shiv Shankar Hemnat on 20.11.2013 // strSql = @"UPDATE [INSTA_MST_SOLUTION] // SET [SOLUTION_NAME] = '" + objGen.gReplaceQuotes(txtName.Text) + @"' // ,[SIZE_ID] = " + ddlSize.SelectedValue + @" // ,[EXHIBIT_DETAIL_ID] = " + ddlExhibitDetail.SelectedValue + @" // ,[MOD_PORT_ID] = " + ddlNature.SelectedValue + @" // ,[PRODUCT_ID] =" + ddlProduct.SelectedValue + @" // ,[DISCOUNT_ID] = " + ddlDiscountRate.Text + @" // ,[PRICE] = " + txtPrice.Text + @" // ,[CURRENCY_ID] =" + ddlCurrency.SelectedValue + @" // ,[SHIPPING_DAYS] = '" + objGen.gReplaceQuotes(txtShippingDays.Text) + @"' // ,[SHIPPING_DISPLAY_FLAG] = " + strDisplayShippingDays + @" // ,[MODIFY_DATE] = getdate() // ,[PRODUCT_FEATURE_DISPLAY_FLAG] = " + strDisplayProductFeature + @" // ,[SOLUTION_TEXT] = '" + objGen.gReplaceQuotes(txtDescription.Text) + @"' // ,[LATEST_FLAG] = " + strMarkAsLatestProduct + @" // ,[INACTIVE_FLAG] = " + strActiveInactive + @" // WHERE SOLUTION_ID =" + Convert.ToString(ViewState["SOLUTION_ID"]); //Modify by Shiv Shankar Hemnat on 20.11.2013 strSql = @"UPDATE [INSTA_MST_SOLUTION] SET [SOLUTION_NAME] = '" + objGen.gReplaceQuotes(txtName.Text) + @"' ,[DESIGNED_FOR] = '" + objGen.gReplaceQuotes(txtDesignFor.Text) + @"' ,[SIZE_ID] = " + ddlSize.SelectedValue + @" ,[EXHIBIT_DETAIL_ID] = " + ddlExhibitDetail.SelectedValue + @" ,[MOD_PORT_ID] = " + ddlNature.SelectedValue + @" ,[INDUSTRY_SEGMENT_ID] = " + strIndustrySegments + @" ,[PRODUCT_ID] =" + ddlProduct.SelectedValue + @" ,[CLIENT_ID] =" + strClientID + @" ,[DISCOUNT_ID] = " + ddlDiscountRate.Text + @" ,[PRICE] = " + txtPrice.Text + @" ,[CURRENCY_ID] =" + ddlCurrency.SelectedValue + @" ,[SHIPPING_DAYS] = '" + objGen.gReplaceQuotes(txtShippingDays.Text) + @"' ,[SHIPPING_DISPLAY_FLAG] = " + strDisplayShippingDays + @" ,[MODIFY_DATE] = SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ,[PRODUCT_FEATURE_DISPLAY_FLAG] = " + strDisplayProductFeature + @" ,[SOLUTION_TEXT] = '" + objGen.gReplaceQuotes(txtDescription.Text) + @"' ,[LATEST_FLAG] = " + strMarkAsLatestProduct + @" ,[INACTIVE_FLAG] = " + strActiveInactive + @" ,[PRODUCT_FLAG] = 0 ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" WHERE SOLUTION_ID =" + Convert.ToString(ViewState["SOLUTION_ID"]); //Added by Shiv Shankar Hemant on 08-11-2013 //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ objHelper.gTransactionHandler(DBHelper.TransactionType.Open); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { strSql = "DELETE FROM [INSTA_MST_SOLUTION_APPLICATION] WHERE SOLUTION_ID =" + Convert.ToString(ViewState["SOLUTION_ID"]); objHelper.gTransactionHandler(DBHelper.TransactionType.Open); if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) >= 0) { strSql = @" INSERT INTO [INSTA_MST_SOLUTION_APPLICATION] ( SOLUTION_ID, APPLICATION_ID) "; bool isFirstRecord = false; for (int iCounter = 0; iCounter < grdSolutionApplication.Rows.Count; iCounter++) { GridViewRow row = grdSolutionApplication.Rows[iCounter]; if (((CheckBox)row.FindControl("chkSubject")).Checked == true) { if (!isFirstRecord) { strSql += " VALUES( " + Convert.ToString(ViewState["SOLUTION_ID"]) + "," + grdSolutionApplication.DataKeys[iCounter].Value.ToString() + " ),"; isFirstRecord = true; } else { strSql += " ( " + Convert.ToString(ViewState["SOLUTION_ID"]) + "," + grdSolutionApplication.DataKeys[iCounter].Value.ToString() + " ),"; } } } //CHECK BOX SELECTION IS NOT MANDATORY. if (isFirstRecord) { strSql = strSql.Substring(0, strSql.LastIndexOf(",")); //----------------------------------------------------------------------- if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) > 0) { objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); return true; } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); return false; } } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Commit); return true; } //----------------------------------------------------------------------- //} //else //{ // objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); // return false; //} } } else { objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); return false; } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_SOLUTION] WHERE SOLUTION_ID =" + Convert.ToString(ViewState["SOLUTION_ID"]); break; } //Commented by Shiv Shankar Hemant on 08-11-2013 //if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) // return true; //else return false; } catch (Exception err) { // Commented by Shiv Shankar Hemnat on 08-11-2013 //lblErrorMessage.Text = err.Message; //divError.Visible = true; //return false; //Modify by Shiav Shankar Hemnat on 08-11-2013 objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback); lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveImagesUpload(enmSaveType enType) { UploadImagesFiles(); //--------------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO [INSTA_MST_CASE_PICS] ([CASE_ID] ,[PIC_NAME] ,[PIC_DESCRIPTION] ,[SORT_ORDER] ,[INACTIVE_FLAG]) VALUES (" + Convert.ToString(ViewState["CASE_ID"]) + @" ,'" + Convert.ToString(ViewState["ImageName"]) + @"' ,'" + objGen.gReplaceQuotes(txtImageDescription.Text) + @"' ," + txtImagesSortOrder.Text + @" ," + ddlImageStatus.SelectedValue + ")"; break; case enmSaveType.Update: strSql = @"UPDATE [INSTA_MST_CASE_PICS] SET [CASE_ID] = " + Convert.ToString(ViewState["CASE_ID"]) + @" ,[PIC_NAME] = '" + Convert.ToString(ViewState["ImageName"]) + @"' ,[PIC_DESCRIPTION] = '" + objGen.gReplaceQuotes(txtImageDescription.Text) + @"' ,[SORT_ORDER] =" + txtImagesSortOrder.Text + @" ,[INACTIVE_FLAG] = " + ddlImageStatus.SelectedValue + @" WHERE [PIC_ID] = " + Convert.ToString(ViewState["PIC_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_CASE_PICS] WHERE [PIC_ID] = " + Convert.ToString(ViewState["PIC_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveVideosUpload(enmSaveType enType) { switch (enType) { case enmSaveType.Insert: //Commentd by Shiv Shankar Hemnat on 20.11.2013 // strSql = @"INSERT INTO [INSTA_MST_VIDEO_LINK] // ([SOLUTION_ID] // ,[VIDEO_LINK] // ,[VIDEO_DESCRIPTION] // ,[LAST_UPLOAD_DATE] // ,[SORT_ORDER] // ,[USER_ID] // ,[INACTIVE_FLAG]) // VALUES // (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,'" + objGen.gReplaceQuotes(txtVideoDescription.Text) + @"' // ,getdate() // ," + txtVideoSortOrder.Text + @" // ,0 // ," + ddlVideoUploadStatus.SelectedValue + ")"; // Modify by Shiv Shankar Hemnat on 20.11.2013 strSql = @"INSERT INTO [INSTA_MST_VIDEO_LINK] ([SOLUTION_ID] ,[VIDEO_LINK] ,[VIDEO_DESCRIPTION] ,[LAST_UPLOAD_DATE] ,[SORT_ORDER] ,[USER_ID] ,[INACTIVE_FLAG]) VALUES (" + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,'" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' ,'" + objGen.gReplaceQuotes(txtVideoDescription.Text) + @"' , SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ," + txtVideoSortOrder.Text + @" , " + Convert.ToString(Session["USER_ID"]) + @" ," + ddlVideoUploadStatus.SelectedValue + ")"; break; case enmSaveType.Update: // Commented by Shiv Shankar Hemnat on 20.11.2013 // strSql = @"UPDATE [INSTA_MST_VIDEO_LINK] // SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" // ,[VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' // ,[VIDEO_DESCRIPTION] = '" + objGen.gReplaceQuotes(txtVideoDescription.Text) + @"' // ,[LAST_UPLOAD_DATE] = GATEDATE() // ,[SORT_ORDER] =" + txtVideoSortOrder.Text + @" // ,[USER_ID] =0 // ,[INACTIVE_FLAG] = " + ddlVideoUploadStatus.SelectedValue + @" // WHERE [VIDEO_LINK_ID] = " + Convert.ToString(ViewState["VIDEO_LINK_ID"]); // Modyfy by Shiv Shankr Hemnat on 20.11.2013 strSql = @"UPDATE [INSTA_MST_VIDEO_LINK] SET [SOLUTION_ID] = " + Convert.ToString(ViewState["SOLUTION_ID"]) + @" ,[VIDEO_LINK] = '" + objGen.gReplaceQuotes(txtVideoLink.Text) + @"' ,[VIDEO_DESCRIPTION] = '" + objGen.gReplaceQuotes(txtVideoDescription.Text) + @"' ,[LAST_UPLOAD_DATE] = SWITCHOFFSET(SYSDATETIMEOFFSET(),'+05:30') ,[SORT_ORDER] =" + txtVideoSortOrder.Text + @" ,[USER_ID] = " + Convert.ToString(Session["USER_ID"]) + @" ,[INACTIVE_FLAG] = " + ddlVideoUploadStatus.SelectedValue + @" WHERE [VIDEO_LINK_ID] = " + Convert.ToString(ViewState["VIDEO_LINK_ID"]); break; case enmSaveType.Delete: strSql = @"DELETE FROM [INSTA_MST_VIDEO_LINK] WHERE [VIDEO_LINK_ID] = " + Convert.ToString(ViewState["VIDEO_LINK_ID"]); break; } //----------------------------------------------------------- if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) { return true; } else return false; //----------------------------------------------------------- }
private bool SaveRecord(enmSaveType enType) { try { switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_CASE (CASE_CATEGORY_ID ,PAGE_HEADER ,PAGE_DESCRIPTION ,PAGE_BANNER_TOP ,PAGE_BANNER_TOP_ALT_TEXT ,PAGE_BANNER_BOTTOM ,PAGE_BANNER_BOTTOM_ALT_TEXT) VALUES(" + ddlCategory.SelectedValue + @", '" + objGen.gReplaceQuotes(txtPageHeader.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtPageDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtPageBannerTop.Text.Trim()) + @", '" + objGen.gReplaceQuotes(txtPageBannerTopAlternateText.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtPageBannerBottom.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtPageBannerBottomAltText.Text.Trim()) + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_CASE SET CASE_CATEGORY_ID =" + ddlCategory.SelectedValue + @", PAGE_HEADER = '" + objGen.gReplaceQuotes(txtPageHeader.Text.Trim()) + @"' , PAGE_DESCRIPTION = '" + objGen.gReplaceQuotes(txtPageDescription.Text.Trim()) + @"' , PAGE_BANNER_TOP = '" + objGen.gReplaceQuotes(txtPageBannerTop.Text.Trim()) + @"' , PAGE_BANNER_TOP_ALT_TEXT = '" + objGen.gReplaceQuotes(txtPageBannerTopAlternateText.Text.Trim()) + @"' , PAGE_BANNER_BOTTOM ='" + objGen.gReplaceQuotes(txtPageBannerBottom.Text.Trim()) + @"' , PAGE_BANNER_BOTTOM_ALT_TEXT ='" + objGen.gReplaceQuotes(txtPageBannerBottomAltText.Text.Trim()) + @"' , WHERE CASE_ID = " + Convert.ToString(ViewState["CASE_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveExhibition(enmSaveType enType) { try { string strMajorConFlg = "0"; string strInactivFlag = "0"; //------------------------------------------- if (chkMajor.Checked) strMajorConFlg = "1"; if (chkInactivFlag.Checked) strInactivFlag = "1"; //------------------------------------------- //Take Date from Client //--------------------------------------------------------------------------- string strStartDate = "NULL"; string strEndDate = "NULL"; if (!string.IsNullOrEmpty(txtStartDate.Text)) strStartDate = "'" + txtStartDate.Text.Substring(6, 4) + "-" + txtStartDate.Text.Substring(3, 2) + "-" + txtStartDate.Text.Substring(0, 2) + "'"; if (!string.IsNullOrEmpty(txtEndDate.Text)) strEndDate = "'" + txtEndDate.Text.Substring(6, 4) + "-" + txtEndDate.Text.Substring(3, 2) + "-" + txtEndDate.Text.Substring(0, 2) + "'"; //-------------------------------------------------------------------------------------- switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_EXHIBITION( EXHIBITION_NAME, EXHIBITION_DETAILS, EXHIBITON_TEXT, EXHIBITON_PERIOD, EXHIBITION_START_DATE, EXHIBITION_END_DATE, EXHIBITION_IMAGE, CITY_ID, USER_ID, EXHIBITION_DISPLAY_FLAG, SORT_ORDER, INACTIVE_FLAG) VALUES('" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtTagLine.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtEventDate.Text.Trim()) + @"', " + strStartDate + @", " + strEndDate + @", '" + Convert.ToString(ViewState["BigImageName"]) + @"', '" + objGen.gReplaceQuotes(ddlCity.SelectedValue) + @"', " + Convert.ToString(Session["USER_ID"]) + @", '" + strMajorConFlg + @"', '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_EXHIBITION SET EXHIBITION_NAME = '" + objGen.gReplaceQuotes(txtName.Text.Trim()) + @"', EXHIBITION_DETAILS = '" + objGen.gReplaceQuotes(txtTagLine.Text.Trim()) + @"', EXHIBITON_TEXT = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', EXHIBITON_PERIOD = '" + objGen.gReplaceQuotes(txtEventDate.Text.Trim()) + @"', EXHIBITION_START_DATE = " + strStartDate + @", EXHIBITION_END_DATE = " + strEndDate + @", EXHIBITION_IMAGE = '" + Convert.ToString(ViewState["BigImageName"]) + @"', CITY_ID = '" + objGen.gReplaceQuotes(ddlCity.SelectedValue) + @"', USER_ID = " + Convert.ToString(Session["USER_ID"]) + @", EXHIBITION_DISPLAY_FLAG = '" + strMajorConFlg + @"', SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE EXHIBITION_ID =" + Convert.ToString(ViewState["EXHIBITION_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }
private bool SaveCity(enmSaveType enType) { try { string strInactivFlag = "0"; if (chkInactivFlag.Checked) strInactivFlag = "1"; switch (enType) { case enmSaveType.Insert: strSql = @"INSERT INTO INSTA_MST_CITY( CITY_NAME, CITY_DETAILS, REGION_ID, CITY_TEXT, CITY_IMAGE, USER_ID, SORT_ORDER, INACTIVE_FLAG) VALUES('" + objGen.gReplaceQuotes(txtCityName.Text.Trim()) + @"', '" + objGen.gReplaceQuotes(txtState.Text.Trim()) + @"', " + objGen.gReplaceQuotes(ddlCountry.SelectedValue) + @", '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', '" + Convert.ToString(ViewState["ImageName"]) + @"', " + Convert.ToString(Session["USER_ID"]) + @", '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', '" + strInactivFlag + "')"; if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; case enmSaveType.Update: strSql = @"UPDATE INSTA_MST_CITY SET CITY_NAME = '" + objGen.gReplaceQuotes(txtCityName.Text.Trim()) + @"', CITY_DETAILS = '" + objGen.gReplaceQuotes(txtState.Text.Trim()) + @"', REGION_ID = '" + objGen.gReplaceQuotes(ddlCountry.SelectedValue) + @"', CITY_TEXT = '" + objGen.gReplaceQuotes(txtDescription.Text.Trim()) + @"', CITY_IMAGE = '" + Convert.ToString(ViewState["ImageName"]) + @"', USER_ID = " + Convert.ToString(Session["USER_ID"]) + @", SORT_ORDER = '" + objGen.gReplaceQuotes(txtShortOrder.Text.Trim()) + @"', INACTIVE_FLAG ='" + strInactivFlag + @"' WHERE CITY_ID =" + Convert.ToString(ViewState["CITY_ID"]); if (objHelper.gExecuteNonQuery(CommandType.Text, strSql) > 0) return true; else return false; } } catch (Exception err) { lblErrorMessage.Text = err.Message; divError.Visible = true; return false; } return true; }