private void btnSave_Click(object sender, EventArgs e)
{
string strSQl = string.Empty;
objData = new SQLDB();
objUtil = new UtilityDB();
string strFBNo = string.Empty;
try
{
if (CheckData())
{
objUserTask = new UserTaskDB();
strFBNo = objUserTask.GenerateFeedBackTranNo().ToString();
strSQl = " INSERT into CRM_FEEDBACK (CF_COMPANY_CODE , CF_STATE_CODE, CF_BRANCH_CODE, CF_FIN_YEAR,CF_TRN_TYPE,CF_TRN_NUMBER,CF_TRN_DATE,CF_TRN_REM,CF_CREATED_BY,CF_CREATED_DATE)" +
" VALUES('" + CommonData.CompanyCode +
"', '" + CommonData.StateCode +
"', '" + CommonData.BranchCode +
"', '" + CommonData.FinancialYear +
"', '" + cbFeedBackType.Text +
"', '" + strFBNo +
"', '" + Convert.ToDateTime(CommonData.CurrentDate).ToString("dd/MMM/yyyy") +
"', '" + txtFeedBack.Text +
"', '" + CommonData.LogUserId +
"', '" + Convert.ToDateTime(CommonData.CurrentDate).ToString("dd/MMM/yyyy") +
"' )";
int rec = objData.ExecuteSaveData(strSQl);
if (rec > 0)
{
objUtil.SendMail(CommonData.LogUserEcode + "-" + CommonData.LogUserName, CommonData.BranchName, txtFeedBack.Text);
}
txtFeedBack.Text = "";
FillFeedBackList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Feed back", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
}
}
