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