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;
}
