public Boolean SaveBankSP(M_Bank oBank, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "Bank_Save"; scom.Parameters.Add("@BANK_CODE", SqlDbType.VarChar, 10).Value = oBank.BANK_CODE; scom.Parameters.Add("@BANK_NAME", SqlDbType.VarChar, 50).Value = oBank.BANK_NAME; scom.Parameters.Add("@BANK_DTRANSFER", SqlDbType.Int).Value = 0; scom.Parameters.Add("@BANK_EXBATCH", SqlDbType.Int).Value = 0; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; u_DBConnection dbcon = new u_DBConnection(); retvalue = dbcon.RunQuery(scom); return(retvalue); } catch (Exception ex) { throw (ex); } }
// POST: api/Bank public IHttpActionResult Post([FromBody] M_Bank bank) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } budegetdbcontext.M_Bank.Add(bank); budegetdbcontext.SaveChanges(); return(Ok()); }
private void button2_Click(object sender, EventArgs e) { M_Bank objbank = new M_Bank(); objbank.BANK_CODE = txt_bankcode.Text.Trim(); objbank.BANK_NAME = txt_name.Text.Trim().ToUpper(); M_BankDL bal = new M_BankDL(); bal.SaveBankSP(objbank, 3); GetData(); }
private void SetValues(String Bank) { try { M_BankDL objBankBL = new M_BankDL(); M_Bank objBank = new M_Bank(); if (Bank != "") { objBank.BANK_CODE = Bank; objBank = objBankBL.SelectBank(objBank); if (objBank != null) { txt_bankcode.Text = objBank.BANK_CODE.ToString(); txt_name.Text = objBank.BANK_NAME.ToString(); //EnableCtrl(false); formMode = 3; //EnableMainContral(formMode, null); //Enable main Buton Contrals 0:NEW 3:EXSISTING RECORD } else // IF object IS NULL CHECK USER CAN HAVE PERMITION SAVE,EDIT ,DELETE { //EnableCtrl(true); //if (AccessValidate("C") == true) //IN USER PERMITION 'C' CHECK USER HAVE PERMETION TO DO THE ACTION //{ // EnableMainContral(formMode, null); //Enable main Buton Contrals 0:NEW 3:EXSISTING RECORD // txtName.Focus(); //} } } else { //EnableCtrl(true); //if (intFlagOtherFrm == 0) // If record comes from other form Then Dont Call Enable contrall // EnableMainContral(formMode, null); //Enable main Buton Contrals 0:NEW 3:EXSISTING RECORD } } catch (Exception ex) { //MessageBox.Show(ex.ToString(), strFormName, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public static string FindExisitingBank(string suppcode) { string str = ""; if (M_BankDL.ExistingBank(suppcode.Trim())) { M_Bank cat = new M_Bank(); cat.BANK_CODE = suppcode.Trim(); M_BankDL dl = new M_BankDL(); cat = dl.SelectBank(cat); str = cat.BANK_NAME; } else { str = "<Error!!!>"; } return(str); }
public M_Bank SelectBank(M_Bank objBank) { try { strquery = @"select * From M_Bank where BANK_CODE = '" + objBank.BANK_CODE + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objBank.BANK_CODE = drType["BANK_CODE"].ToString(); objBank.BANK_NAME = drType["BANK_NAME"].ToString(); return(objBank); } return(null); } catch (Exception ex) { throw ex; } }
private void performButtons(xEnums.PerformanceType xenum) { switch (xenum) { case xEnums.PerformanceType.View: if (ActiveControl.Name.Trim() == txt_bankcode.Name.Trim()) { int length = Convert.ToInt32(ConfigurationManager.AppSettings["BankFieldLength"]); string[] strSearchField = new string[length]; string strSQL = ConfigurationManager.AppSettings["BankSQL"].ToString(); for (int i = 0; i < length; i++) { string m; m = i.ToString(); strSearchField[i] = ConfigurationManager.AppSettings["BankField" + m + ""].ToString(); } frmU_Search find = new frmU_Search(strSQL, strSearchField, this); find.ShowDialog(this); } break; case xEnums.PerformanceType.New: FunctionButtonStatus(xEnums.PerformanceType.New); formMode = 1; txt_bankcode.Focus(); break; case xEnums.PerformanceType.Edit: FunctionButtonStatus(xEnums.PerformanceType.Edit); formMode = 2; txt_name.Focus(); break; case xEnums.PerformanceType.Save: if (txt_bankcode.Text.Trim() == "") { errorProvider1.SetError(txt_bankcode, "Please enter a bank Code !"); return; } if (txt_name.Text.Trim() == "") { errorProvider1.SetError(txt_name, "Please enter a bank name !"); return; } if (formMode == 1) { if (M_BankDL.ExistingBank(txt_bankcode.Text.Trim())) { UserDefineMessages.ShowMsg("The bank code you have entered already exists!", UserDefineMessages.Msg_Warning); return; } if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Bank objbank = new M_Bank(); objbank.BANK_CODE = txt_bankcode.Text.Trim(); objbank.BANK_NAME = txt_name.Text.Trim().ToUpper(); M_BankDL bal = new M_BankDL(); bal.SaveBankSP(objbank, 1); GetData(); FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2); } } else if (formMode == 2) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Bank objbank = new M_Bank(); objbank.BANK_CODE = txt_bankcode.Text.Trim(); objbank.BANK_NAME = txt_name.Text.Trim().ToUpper(); M_BankDL bal = new M_BankDL(); bal.SaveBankSP(objbank, 3); GetData(); FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2); } } break; case xEnums.PerformanceType.Cancel: FunctionButtonStatus(xEnums.PerformanceType.Default); break; case xEnums.PerformanceType.Print: string reporttitle = "List of All Banks".ToUpper(); frm_reportViwer rpt = new frm_reportViwer(); rpt.MdiParent = MDI_SMartAnything.ActiveForm; rpt.FormHeadertext = reporttitle; ParameterField paramField = new ParameterField(); ParameterFields paramFields = new ParameterFields(); paramFields = commonFunctions.AddCrystalParams(reporttitle, commonFunctions.Loginuser); rpt_banks rptBank = new rpt_banks(); M_BankDL bankdlx = new M_BankDL(); rptBank.SetDataSource(bankdlx.SelectAllBanks()); rpt.RepViewer.ParameterFieldInfo = paramFields; rpt.RepViewer.ReportSource = rptBank; rpt.RepViewer.Refresh(); rpt.Show(); break; } }