public List <ReceviedVoucherModel> GetReceviedVoucherbyId(int id)
{
List <ReceviedVoucherModel> lstRecevied = new List <ReceviedVoucherModel>();
ReceviedVoucherModel objRecevied;
string Query = "SELECT * FROM Recevied_Voucher WHERE Recevied_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objRecevied = new ReceviedVoucherModel();
objRecevied.RV_Id = DataFormat.GetInteger(dr["Recevied_ID"]);
objRecevied.Date = DataFormat.GetDateTime(dr["Recevied_Date"]);
objRecevied.Series = dr["Series"].ToString();
objRecevied.issuingoffice = dr["Issuing Office"].ToString();
objRecevied.fromNo = DataFormat.GetInteger(dr["FromNo"]);
objRecevied.party = dr["Party"].ToString();
objRecevied.issuedDate = DataFormat.GetDateTime(dr["DateOfIssue"]);
objRecevied.stateofissue = dr["StateOfIssue"].ToString();
objRecevied.Narration = dr["Narration"].ToString();
//SELECT Recevied Amount Voucher
string itemQuery = "SELECT * FROM Recevied_Amount_Voucher WHERE Recevied_Id=" + id;
System.Data.IDataReader drRec = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objRecevied.ReceviedModel = new List <ReceviedModel>();
ReceviedModel objrec;
while (drRec.Read())
{
objrec = new ReceviedModel();
objrec.id = DataFormat.GetInteger(drRec["SNo"]);
objrec.ParentId = DataFormat.GetInteger(drRec["Recevied_ID"]);
objrec.VoucherNo = DataFormat.GetInteger(drRec["VoucherNo"]);
objrec.Dated = drRec["Dated"].ToString();
objrec.Amount = Convert.ToDecimal(drRec["Amount"]);
objRecevied.ReceviedModel.Add(objrec);
}
lstRecevied.Add(objRecevied);
}
return(lstRecevied);
}
private void btnSave_Click(object sender, EventArgs e)
{
ReceviedVoucherModel objissued = new ReceviedVoucherModel();
objissued.Date = Convert.ToDateTime(dtDate.Text);
objissued.form = tbxForm.Text.Trim();
objissued.fromNo = Convert.ToInt32(tbxFormNumber.Text);
objissued.Series = tbxSeries.Text.Trim();
objissued.issuingoffice = tbxIssingoffice.Text.Trim();
objissued.issuedDate = Convert.ToDateTime(dtDateIssue.Text);
objissued.Narration = tbxNarration.Text.Trim();
objissued.stateofissue = tbxStateIssue.Text.Trim();
objissued.party = tbxParty.Text.Trim();
//Form Recevied Details
ReceviedModel objModel;
List <ReceviedModel> lstIssued = new List <ReceviedModel>();
for (int i = 0; i < gdvFormsRcvd.DataRowCount; i++)
{
DataRow row = gdvFormsRcvd.GetDataRow(i);
objModel = new ReceviedModel();
objModel.VoucherNo = Convert.ToInt32(row["VoucherNumber"]);
objModel.Dated = row["Dated"].ToString();
objModel.Amount = Convert.ToInt32(row["Amount"].ToString());
lstIssued.Add(objModel);
}
objissued.ReceviedModel = lstIssued;
bool isSuccess = objrcvdbl.SaveReceviedVoucher(objissued);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
public bool SaveReceviedVoucher(ReceviedVoucherModel objRecevied)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objRecevied.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Series", objRecevied.Series));
paramCollection.Add(new DBParameter("@IssuingOffice", objRecevied.issuingoffice));
paramCollection.Add(new DBParameter("@FromNo", objRecevied.fromNo));
paramCollection.Add(new DBParameter("@Party", objRecevied.party));
paramCollection.Add(new DBParameter("@DateOfIssue", objRecevied.issuedDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@StateOfIssue", objRecevied.stateofissue));
paramCollection.Add(new DBParameter("@Narration", objRecevied.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Recevied_Voucher([Recevied_Date],[Series],[Issuing Office],[FromNo],[Party],[DateOfIssue]," +
"[StateOfIssue],[Narration],[CreatedBy]) VALUES " +
"(@Date,@Series,@IssuingOffice,@FromNo,@Party,@DateOfIssue,@StateOfIssue,@Narration," +
" @CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveReceviedAccount(objRecevied.ReceviedModel);
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveReceviedVoucher(ReceviedVoucherModel objRecevied)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objRecevied.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Form", objRecevied.form));
paramCollection.Add(new DBParameter("@Series", objRecevied.Series));
paramCollection.Add(new DBParameter("@Issuingoffice", objRecevied.issuingoffice));
paramCollection.Add(new DBParameter("@Formnumber", objRecevied.fromNo));
paramCollection.Add(new DBParameter("@DateofIssue", objRecevied.issuedDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Stateofissue", objRecevied.stateofissue));
paramCollection.Add(new DBParameter("@Party", objRecevied.party));
paramCollection.Add(new DBParameter("@Narration", objRecevied.Narration));
paramCollection.Add(new DBParameter("@TotalAmount", "0"));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertFormRcvdMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveReceviedDetails(objRecevied.ReceviedModel, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//Udate Recevied Voucher
public bool UpdateReceviedVoucher(ReceviedVoucherModel objRecevied)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE Recevied TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objRecevied.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Series", objRecevied.Series));
paramCollection.Add(new DBParameter("@IssuingOffice", objRecevied.issuingoffice));
paramCollection.Add(new DBParameter("@FromNo", objRecevied.fromNo));
paramCollection.Add(new DBParameter("@Party", objRecevied.party));
paramCollection.Add(new DBParameter("@DateOfIssue", objRecevied.issuedDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@StateOfIssue", objRecevied.stateofissue));
paramCollection.Add(new DBParameter("@Narration", objRecevied.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@id", objRecevied.RV_Id));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Recevied_Voucher SET [Recevied_Date]=@Date,[Series]=@Series,[Issuing Office]=@IssuingOffice," +
"[FromNo]=@FromNo,[Party]=@Party,[DateOfIssue]=@DateOfIssue,[StateOfIssue]=StateOfIssue,[Narration]=@Narration," +
"[ModifiedBy]=@ModifiedBy " +
" WHERE Recevied_Id=@id";
//Query = "UPDATE Recevied_Voucher SET [Recevied_Date]=@Date,[Series]=@Series,[Issuing Office]=@IssuingOffice," +
// "[FromNo]=@FromNo,[Party]=@Party,[DateOfIssue]=@DateOfIssue,[StateOfIssue]=StateOfIssue,[Narration]=@Narration," +
// "[ModifiedBy]=@ModifiedBy " +
// "WHERE Recevied_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <ReceviedModel> lstAcct = new List <ReceviedModel>();
//UPDATE CREDIT NOTE ACCOUNT -CHILD TABLE UPDATES
foreach (ReceviedModel act in objRecevied.ReceviedModel)
{
if (act.id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNo", (act.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", act.Dated));
paramCollection.Add(new DBParameter("@amount", act.Amount));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ID", (act.id)));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Recevied_Amount_Voucher SET [VoucherNo]=@VoucherNo," +
"[Dated]=@Dated,[Amount]=@amount,[ModifiedBy]=@ModifiedBy " +
"WHERE [SNo]=@ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ID", (objRecevied.RV_Id)));
paramCollection.Add(new DBParameter("@VoucherNo", (act.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", act.Dated));
paramCollection.Add(new DBParameter("@amount", act.Amount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Recevied_Amount_Voucher ([Recevied_Id],[VoucherNo],[Dated],[Amount]," +
"[CreatedBy]) VALUES " +
"(@ID,@VoucherNo,@Dated,@amount,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}