public int InsertExpenceHeadDetail(ref ExpencesHeadMaster Entity_EH, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(ExpencesHeadMaster._Action, SqlDbType.BigInt); SqlParameter pExpenceId = new SqlParameter(ExpencesHeadMaster._ExpenceId, SqlDbType.BigInt); SqlParameter pPerticulars = new SqlParameter(ExpencesHeadMaster._Perticulars, SqlDbType.NVarChar); SqlParameter pRate = new SqlParameter(ExpencesHeadMaster._Rate, SqlDbType.Decimal); SqlParameter pQty = new SqlParameter(ExpencesHeadMaster._Qty, SqlDbType.Decimal); SqlParameter pAmount = new SqlParameter(ExpencesHeadMaster._Amount, SqlDbType.Decimal); SqlParameter pRemark = new SqlParameter(ExpencesHeadMaster._Remark, SqlDbType.NVarChar); pAction.Value = 4; pExpenceId.Value = Entity_EH.ExpenceId; pPerticulars.Value = Entity_EH.Perticulars; pRate.Value = Entity_EH.Rate; pQty.Value = Entity_EH.Qty; pAmount.Value = Entity_EH.Amount; pRemark.Value = Entity_EH.Remark; SqlParameter[] param = new SqlParameter[] { pAction, pExpenceId, pPerticulars, pRate, pQty, pAmount, pRemark }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ExpencesHeadMaster.SP_ExpenceHeadMaster, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int UpdatetExpenceHead(ref ExpencesHeadMaster Entity_EM, out string StrError) { StrError = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(ExpencesHeadMaster._Action, SqlDbType.BigInt); SqlParameter pExpenceId = new SqlParameter(ExpencesHeadMaster._ExpenceId, SqlDbType.BigInt); SqlParameter pExpenceNo = new SqlParameter(ExpencesHeadMaster._ExpenceNo, SqlDbType.NVarChar); SqlParameter pExpenceDate = new SqlParameter(ExpencesHeadMaster._ExpenceDate, SqlDbType.DateTime); SqlParameter pPropertyId = new SqlParameter(ExpencesHeadMaster._PropertyId, SqlDbType.BigInt); SqlParameter pCreatedby = new SqlParameter(ExpencesHeadMaster._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(ExpencesHeadMaster._LoginDate, SqlDbType.DateTime); pAction.Value = 2; pExpenceNo.Value = Entity_EM.ExpenceNo; pExpenceId.Value = Entity_EM.ExpenceId; pExpenceDate.Value = Entity_EM.ExpenceDate; pPropertyId.Value = Entity_EM.PropertyId; pCreatedby.Value = Entity_EM.UserId; pCreatedDate.Value = Entity_EM.LoginDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pExpenceNo, pExpenceId, pExpenceDate, pPropertyId, pCreatedby, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ExpencesHeadMaster.SP_ExpenceHeadMaster, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { StrError = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }
public int InsertExpenceHead(ref ExpencesHeadMaster Entity_EH, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(ExpencesHeadMaster._Action, SqlDbType.BigInt); SqlParameter pExpenceNo = new SqlParameter(ExpencesHeadMaster._ExpenceNo, SqlDbType.NVarChar); SqlParameter pExpenceDate = new SqlParameter(ExpencesHeadMaster._ExpenceDate, SqlDbType.DateTime); SqlParameter pPropertyId = new SqlParameter(ExpencesHeadMaster._PropertyId, SqlDbType.BigInt); SqlParameter pCreatedBy = new SqlParameter(ExpencesHeadMaster._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(ExpencesHeadMaster._LoginDate, SqlDbType.DateTime); pAction.Value = 1; pExpenceNo.Value = Entity_EH.ExpenceNo; pExpenceDate.Value = Entity_EH.ExpenceDate; pPropertyId.Value = Entity_EH.PropertyId; pCreatedBy.Value = Entity_EH.UserId; pCreatedDate.Value = Entity_EH.LoginDate; SqlParameter[] param = new SqlParameter[] { pAction, pExpenceNo, pExpenceDate, pPropertyId, pCreatedBy, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, "SP_ExpenceHeadMaster", param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }