public bool SavePettyCashDetails(Attendance.Entities.PettyCashInfo objInfo, int EnteredBy, string Locationname) { bool success = false; try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString()); con.Open(); SqlCommand command = new SqlCommand("[USP_PettycashDetails]", con); command.CommandType = CommandType.StoredProcedure; //command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID; command.Parameters.Add("@AccountHolderName", SqlDbType.VarChar).Value = objInfo.AccountName; command.Parameters.Add("@IncomeType", SqlDbType.VarChar).Value = objInfo.AmountType; command.Parameters.Add("@AcountDate", SqlDbType.DateTime).Value = objInfo.AccountDate; command.Parameters.Add("@BillNo", SqlDbType.VarChar).Value = objInfo.BillNum; command.Parameters.Add("@chequeNo", SqlDbType.VarChar).Value = objInfo.ChequeNum; command.Parameters.Add("@locationname", SqlDbType.VarChar).Value = Locationname; command.Parameters.Add("@EnteredBy", SqlDbType.Int).Value = EnteredBy; command.Parameters.Add("@expenditureAmount", SqlDbType.VarChar).Value = objInfo.ExpenseAmount; command.Parameters.Add("@Expdate", SqlDbType.DateTime).Value = objInfo.ExpenseDate; //command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID; command.Parameters.Add("@ServicemanName", SqlDbType.VarChar).Value = objInfo.ExpenseManName; command.Parameters.Add("@expenditureSubtype", SqlDbType.VarChar).Value = objInfo.ExpenseSubType; command.Parameters.Add("@expenditureTpe", SqlDbType.VarChar).Value = objInfo.Expensetype; command.Parameters.Add("@FromWhom", SqlDbType.VarChar).Value = objInfo.FromWhom; command.Parameters.Add("@Income", SqlDbType.VarChar).Value = objInfo.InitialAmoun; command.Parameters.Add("@expenditureNotes", SqlDbType.VarChar).Value = objInfo.Notes; command.Parameters.Add("@VoucherNo", SqlDbType.VarChar).Value = objInfo.VoucherNum; command.ExecuteNonQuery(); con.Close(); success = true; } catch (Exception ex) { } return(success); }
protected void btnSave_Click(object sender, EventArgs e) { try { Attendance.Entities.PettyCashInfo objInfo = new Attendance.Entities.PettyCashInfo(); objInfo.AccountName = txtName.Text==""?"":GeneralFunction.ToProper(txtName.Text); objInfo.AmountType = ddlIncomeType.SelectedItem.Text; objInfo.AccountDate = txtDate.Text == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(txtDate.Text); objInfo.InitialAmoun = txtIncome.Text; objInfo.FromWhom = txtFrmWhom.Text == "" ? "" : GeneralFunction.ToProper(txtFrmWhom.Text); objInfo.ChequeNum = txtChequeNum.Text; objInfo.ExpenseAmount = txtExpenseAmnt.Text; objInfo.ExpenseDate = txtExpenseDate.Text == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(txtExpenseDate.Text); objInfo.Expensetype = txtExpenseType.Text; objInfo.ExpenseSubType = txtExpenseSubType.Text; objInfo.ExpenseManName = txtServiceName.Text == "" ? "" : GeneralFunction.ToProper(txtServiceName.Text); objInfo.BillNum = txtBillNum.Text; objInfo.VoucherNum = txtVoucherNum.Text; objInfo.Notes = txtNotes.Text == "" ? "" : GeneralFunction.ToProperNotes(txtNotes.Text); string Locationname = Session["LocationName"].ToString(); int UserID = Convert.ToInt32(Session["UserID"]); Attendance.BAL.Report obj = new Report(); bool bnew = obj.SavePettyCashDetails(objInfo, UserID, Locationname); if (bnew) { System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Saved successfully..');", true); GetPettyCashDetails(); } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { try { Attendance.Entities.PettyCashInfo objInfo = new Attendance.Entities.PettyCashInfo(); objInfo.AccountName = txtName.Text == ""?"":GeneralFunction.ToProper(txtName.Text); objInfo.AmountType = ddlIncomeType.SelectedItem.Text; objInfo.AccountDate = txtDate.Text == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(txtDate.Text); objInfo.InitialAmoun = txtIncome.Text; objInfo.FromWhom = txtFrmWhom.Text == "" ? "" : GeneralFunction.ToProper(txtFrmWhom.Text); objInfo.ChequeNum = txtChequeNum.Text; objInfo.ExpenseAmount = txtExpenseAmnt.Text; objInfo.ExpenseDate = txtExpenseDate.Text == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(txtExpenseDate.Text); objInfo.Expensetype = txtExpenseType.Text; objInfo.ExpenseSubType = txtExpenseSubType.Text; objInfo.ExpenseManName = txtServiceName.Text == "" ? "" : GeneralFunction.ToProper(txtServiceName.Text); objInfo.BillNum = txtBillNum.Text; objInfo.VoucherNum = txtVoucherNum.Text; objInfo.Notes = txtNotes.Text == "" ? "" : GeneralFunction.ToProperNotes(txtNotes.Text); string Locationname = Session["LocationName"].ToString(); int UserID = Convert.ToInt32(Session["UserID"]); Attendance.BAL.Report obj = new Report(); bool bnew = obj.SavePettyCashDetails(objInfo, UserID, Locationname); if (bnew) { System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Saved successfully..');", true); GetPettyCashDetails(); } } catch (Exception ex) { } }