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);
}
