private void expenseRegisterToolStripMenuItem_Click(object sender, EventArgs e) { ExpenseRegister expenseRegister = new ExpenseRegister(); expenseRegister.Show(); expenseRegister.MdiParent = this; }
public int UpdatetExpenceHead(ref ExpenseRegister Entity_EM, out string StrError) { StrError = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(ExpenseRegister._Action, SqlDbType.BigInt); SqlParameter pExpregId = new SqlParameter(ExpenseRegister._ExpregId, SqlDbType.BigInt); SqlParameter pExpRegNo = new SqlParameter(ExpenseRegister._ExpRegNo, SqlDbType.NVarChar); SqlParameter pExpenceRegDate = new SqlParameter(ExpenseRegister._ExpenceRegDate, SqlDbType.DateTime); SqlParameter pPropertyId = new SqlParameter(ExpenseRegister._PropertyId, SqlDbType.BigInt); SqlParameter pUnitNo = new SqlParameter(ExpenseRegister._UnitNo, SqlDbType.NVarChar); SqlParameter pExpenseHdId = new SqlParameter(ExpenseRegister._ExpenseHdId, SqlDbType.BigInt); SqlParameter pCreatedby = new SqlParameter(ExpenseRegister._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(ExpenseRegister._LoginDate, SqlDbType.DateTime); pAction.Value = 2; pExpRegNo.Value = Entity_EM.ExpRegNo; pExpregId.Value = Entity_EM.ExpregId; pExpenceRegDate.Value = Entity_EM.ExpenceRegDate; pPropertyId.Value = Entity_EM.PropertyId; pUnitNo.Value = Entity_EM.UnitNo; pExpenseHdId.Value = Entity_EM.ExpenseHdId; pCreatedby.Value = Entity_EM.UserId; pCreatedDate.Value = Entity_EM.LoginDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pExpRegNo, pExpregId, pExpenceRegDate, pPropertyId, pUnitNo, pExpenseHdId, pCreatedby, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ExpenseRegister.SP_ExpenceRegisterMaster, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { StrError = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }
public int InsertExpenceHead(ref ExpenseRegister Entity_EH, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(ExpenseRegister._Action, SqlDbType.BigInt); SqlParameter pExpRegNo = new SqlParameter(ExpenseRegister._ExpRegNo, SqlDbType.NVarChar); SqlParameter pPropertyId = new SqlParameter(ExpenseRegister._PropertyId, SqlDbType.BigInt); SqlParameter pUnitNo = new SqlParameter(ExpenseRegister._UnitNo, SqlDbType.NVarChar); SqlParameter pExpenceRegDate = new SqlParameter(ExpenseRegister._ExpenceRegDate, SqlDbType.DateTime); SqlParameter pCreatedBy = new SqlParameter(ExpenseRegister._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(ExpenseRegister._LoginDate, SqlDbType.DateTime); pAction.Value = 1; pExpRegNo.Value = Entity_EH.ExpRegNo; pExpenceRegDate.Value = Entity_EH.ExpenceRegDate; pPropertyId.Value = Entity_EH.PropertyId; pUnitNo.Value = Entity_EH.UnitNo; pCreatedBy.Value = Entity_EH.UserId; pCreatedDate.Value = Entity_EH.LoginDate; SqlParameter[] param = new SqlParameter[] { pAction, pExpRegNo, pExpenceRegDate, pPropertyId, pUnitNo, pCreatedBy, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, "SP_ExpenceRegisterMaster", param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int InsertExpenceHeadDetail(ref ExpenseRegister Entity_EH, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(ExpenseRegister._Action, SqlDbType.BigInt); SqlParameter pExpregId = new SqlParameter(ExpenseRegister._ExpregId, SqlDbType.BigInt); SqlParameter pExpenseHdId = new SqlParameter(ExpenseRegister._ExpenseHdId, SqlDbType.BigInt); SqlParameter pAmount = new SqlParameter(ExpenseRegister._Amount, SqlDbType.Decimal); SqlParameter pRemark = new SqlParameter(ExpenseRegister._Remark, SqlDbType.NVarChar); pAction.Value = 4; pExpregId.Value = Entity_EH.ExpregId; pExpenseHdId.Value = Entity_EH.ExpenseHdId; pAmount.Value = Entity_EH.Amount; pRemark.Value = Entity_EH.Remark; SqlParameter[] param = new SqlParameter[] { pAction, pExpregId, pExpenseHdId, pAmount, pRemark }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ExpenseRegister.SP_ExpenceRegisterMaster, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }