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