public static Entity.PurchaseOrder.PurchaseOrderEntry GetAllById(int PurchaseBillId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@PurchaseBillId", SqlDbType.Int, PurchaseBillId);
SqlDataReader dr = oDm.ExecuteReader("usp_PurchaseBillEntry_GetAllById");
Entity.PurchaseOrder.PurchaseOrderEntry Entry = new Entity.PurchaseOrder.PurchaseOrderEntry();
if (dr.HasRows)
{
while (dr.Read())
{
Entry.PurchaseBillId = PurchaseBillId;
Entry.BillNo = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
Entry.BillDate = (dr[2] == DBNull.Value) ? DateTime.MinValue : DateTime.Parse(dr[2].ToString());
Entry.BillAmount = (dr[3] == DBNull.Value) ? 0 : decimal.Parse(dr[3].ToString());
Entry.SupplierLedgerID_FK = (dr[4] == DBNull.Value) ? 0 : int.Parse(dr[4].ToString());
Entry.PurchaseLedgerID_FK = (dr[5] == DBNull.Value) ? 0 : int.Parse(dr[5].ToString());
Entry.Narration = (dr[6] == DBNull.Value) ? "" : (dr[6].ToString());
}
}
return(Entry);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strValues = txtBillDate.Text;
strValues += chr.ToString() + "";
DataSet ds_fn = gf.ExecuteSelectSP("spSelect_GetFnYear", strValues);
if (ds_fn.Tables[0].Rows[0]["FinYearID"].ToString() == Session["FinYrID"].ToString().Trim())
{
if (Validate())
{
BusinessLayer.PurchaseOrder.PurchaseOrderEntry ObjPO = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
Entity.PurchaseOrder.PurchaseOrderEntry PO = new Entity.PurchaseOrder.PurchaseOrderEntry();
PO.PurchaseBillId = PurchaseBillId;
PO.BillNo = txtBillNo.Text.Trim();
PO.BillDate = Convert.ToDateTime(txtBillDate.Text.Trim());
PO.BillAmount = decimal.Parse(txtBillAmt.Text.Trim());
PO.SupplierLedgerID_FK = int.Parse(ddlSupplier.SelectedValue);
PO.PurchaseLedgerID_FK = int.Parse(ddlPurchaseLedger.SelectedValue.Trim());
PO.CompanyID_FK = Convert.ToInt32(Session["CompanyId"].ToString());
PO.BranchID_FK = Convert.ToInt32(Session["BranchId"].ToString());
PO.FinYearID_FK = Convert.ToInt32(Session["FinYrID"].ToString());
PO.DataFlow = Convert.ToInt32(Session["DataFlow"].ToString());
PO.Narration = txtNarration.Text.Trim();
PO.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name);
PO.ModifiedBy = int.Parse(HttpContext.Current.User.Identity.Name);
int RowsAffected = ObjPO.Save(PO);
if (RowsAffected != -1)
{
Message.IsSuccess = true;
Message.Text = "Data Saved Successfully";
ClearControls();
LoadPOList();
}
else
{
Message.IsSuccess = false;
Message.Text = "Can Not Save. Duplicate Bill No is Not Allowed. Please Check";
}
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Please select a Date Between " + Session["SesFromDate"].ToString() + " & " + Session["SesToDate"].ToString() + "";
}
Message.Show = true;
}
protected void LoadPODetails()
{
BusinessLayer.PurchaseOrder.PurchaseOrderEntry ObjPO = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
Entity.PurchaseOrder.PurchaseOrderEntry PO = new Entity.PurchaseOrder.PurchaseOrderEntry();
PO = ObjPO.GetAllById(PurchaseBillId);
if (PO != null)
{
txtBillNo.Text = PO.BillNo;
txtBillDate.Text = PO.BillDate.ToString("dd MMM yyyy");
txtBillAmt.Text = PO.BillAmount.ToString("#0.00");
ddlSupplier.SelectedValue = PO.SupplierLedgerID_FK.ToString();
ddlPurchaseLedger.SelectedValue = PO.PurchaseLedgerID_FK.ToString();
txtNarration.Text = PO.Narration.ToString();
btnSave.Text = "Update";
Message.Show = false;
}
}
public static int Save(Entity.PurchaseOrder.PurchaseOrderEntry Entry)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@PurchaseBillId", SqlDbType.Int, Entry.PurchaseBillId);
oDm.Add("@BillNo", SqlDbType.VarChar, 50, Entry.BillNo);
oDm.Add("@BillDate", SqlDbType.DateTime, Entry.BillDate);
oDm.Add("@BillAmount", SqlDbType.Decimal, Entry.BillAmount);
oDm.Add("@SupplierLedgerID_FK", SqlDbType.Int, Entry.SupplierLedgerID_FK);
oDm.Add("@PurchaseLedgerID_FK", SqlDbType.Int, Entry.PurchaseLedgerID_FK);
oDm.Add("@CompanyID_FK", SqlDbType.Int, Entry.CompanyID_FK);
oDm.Add("@BranchID_FK", SqlDbType.Int, Entry.BranchID_FK);
oDm.Add("@FinYearID_FK", SqlDbType.Int, Entry.FinYearID_FK);
oDm.Add("@Narration", SqlDbType.VarChar, Entry.Narration);
oDm.Add("@DataFlow", SqlDbType.Int, Entry.DataFlow);
oDm.Add("@CreatedBy", SqlDbType.Int, Entry.CreatedBy);
oDm.Add("@ModifiedBy", SqlDbType.Int, Entry.ModifiedBy);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("usp_PurchaseBillEntry_Save"));
}
}
public int Save(Entity.PurchaseOrder.PurchaseOrderEntry Entry)
{
return(DataAccess.PurchaseOrder.PurchaseOrderEntry.Save(Entry));
}