public void SelectAdjustmentVoucher()
{
int i = Convert.ToInt32(Session["userid"].ToString());
AdjustmentService adjService = new AdjustmentService();
dgvAdjustmentVoucher.DataSource = adjService.getTransactionForAdjVoucher(i.ToString()) ;
dgvAdjustmentVoucher.DataBind();
}
public void FillData()
{
AdjustmentService adjService = new AdjustmentService();
var adjHeader = adjService.getAdjustmentVoucherByID(Convert.ToInt32(AdjustmentVoucherID));
//Data From DataBase
// a.ADVID,a.ADVDate,a.ADVStatus,a.employee.EmployeeName ,ApprovedBy =a.employee1.EmployeveName
Type t = adjHeader.GetType();
PropertyInfo adj_status = t.GetProperty("ADVStatus");
PropertyInfo adj_Date = t.GetProperty("ADVDate");
PropertyInfo adj_EmpName = t.GetProperty("StoreEmpName");
string status = adj_status.GetValue(adjHeader, null).ToString();
string date = adj_Date.GetValue(adjHeader, null).ToString();
string empName = adj_EmpName.GetValue(adjHeader, null).ToString();
lblDate.Text = date;
lblStoreClerkID.Text = empName;
Double total = adjService.getAdjustmentVoucherTotal(Convert.ToInt32(AdjustmentVoucherID));
if (status == "Pending" )
{
int userID = Convert.ToInt32(Session["userid"].ToString());
string[] roles;
string role;
roles= Roles.GetRolesForUser();
role = roles[0];
if (role == "Store Manager" && total < 250)
{
btnApprove.Visible = false;
btnApprove.Enabled = false;
btnReject.Visible = false;
btnReject.Enabled = false;
}
else if (role == "Store Supervisor" && total >=250)
{
btnApprove.Visible = false;
btnApprove.Enabled = false;
btnReject.Visible = false;
btnReject.Enabled = false;
}
}
else
{
btnApprove.Visible = true;
btnApprove.Enabled = true;
btnReject.Visible = true;
btnReject.Enabled = true;
}
dgvAdjDetails.DataSource = adjService.getAdjustmentVoucherDetail(Convert.ToInt32(AdjustmentVoucherID));
dgvAdjDetails.DataBind();
dgvAdjDetails.Enabled = false;
}
public void FillData()
{
AdjustmentService adjService = new AdjustmentService();
dgvAdjustmentVoucher.Visible = false;
dgvAdjustmentVoucher.Enabled = false;
btnSubmit.Visible = false;
dgvAdjDetails.DataSource = adjService.getAdjustmentVoucherDetail(Convert.ToInt32(AdjustmentVoucherID));
dgvAdjDetails.DataBind();
dgvAdjDetails.Enabled = false;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
AdjustmentService service = new AdjustmentService();
adjustmentvoucher adjVoucher = new adjustmentvoucher();
adjVoucher.ADVDate = DateTime.Today;
int userID = Convert.ToInt32(Session["userid"].ToString());
adjVoucher.ADVIOrderByEmpID = userID;
// adjVoucher.ADVApprovedByEMpID = 2;
adjVoucher.ADVStatus = "Pending";
double totalPrice = 0;
List<adjustmentvoucherdetail> detailList = new List<adjustmentvoucherdetail>();
foreach (GridViewRow i in dgvAdjustmentVoucher.Rows)
{
adjustmentvoucherdetail adjVoucher_details = new adjustmentvoucherdetail();
adjVoucher_details.ADVID = Convert.ToInt32(i.Cells[6].Text.ToString());
adjVoucher_details.ADVItemID = Convert.ToInt32(i.Cells[0].Text.ToString());
adjVoucher_details.ADVItemUnitCost = 0;
adjVoucher_details.ADVQuantAdj = Convert.ToInt32(i.Cells[2].Text.ToString());
TextBox t = (TextBox)i.FindControl("txtReason");
int itemafter = Convert.ToInt32(i.Cells[5].Text.ToString());
int quantbefore = itemafter + adjVoucher_details.ADVQuantAdj;
adjVoucher_details.ADVReason = t.Text.ToString();
adjVoucher_details.ADVItemUnitCost = Convert.ToInt32(i.Cells[3].Text.ToString());
adjVoucher_details.ADVQuantBefore = quantbefore;
adjVoucher_details.ADVQuantAfter = Convert.ToInt32(i.Cells[5].Text.ToString());
adjVoucher_details.ADVAdjustedCost = Convert.ToInt32(i.Cells[4].Text.ToString());
detailList.Add(adjVoucher_details);
totalPrice = totalPrice + adjVoucher_details.ADVAdjustedCost;
}
service.saveAdjustmentVoucher(adjVoucher, detailList ,totalPrice);
Response.Redirect("ViewStockAdjustmentList.aspx");
}
catch (Exception ex)
{
Label1.Text = "Un expected error occurs! please contact to admin";
}
}
void acceptAdjustmentVoucher()
{
AdjustmentService service = new AdjustmentService();
dgvStockAdjustmentList.DataSource = service.getAdjustmentVoucher();
dgvStockAdjustmentList.DataBind();
}
public void UpdateAdjustmentVoucher(String status)
{
AdjustmentService services = new AdjustmentService();
int userID = Convert.ToInt32(Session["userid"].ToString());
services.updateAdjustmentVoucher(Convert.ToInt32(AdjustmentVoucherID), status, userID);
Response.Redirect("./ViewAdjustmentVoucherListBySupervisor.aspx");
}