protected void gvFoodTransactionItemRelation_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblfID = (Label)e.Row.FindControl("lblfID");
Label lblFoodItem = (Label)e.Row.FindControl("lblFoodItem");
Label lblfRATE = (Label)e.Row.FindControl("lblfRATE");
Label lblfQTY = (Label)e.Row.FindControl("lblfQTY");
Label lblSubTotal = (Label)e.Row.FindControl("lblSubTotal");
Label lblTOTALAMT = (Label)e.Row.FindControl("lblTOTALAMT");
Label lblCUSTID = (Label)e.Row.FindControl("lblCUSTID");
Label lblLOCATIONID = (Label)e.Row.FindControl("lblLOCATIONID");
Label lblRECEIVERID = (Label)e.Row.FindControl("lblRECEIVERID");
Label lblCUSTFname = (Label)e.Row.FindControl("lblCUSTFname");
Label lblLOCATIONName = (Label)e.Row.FindControl("lblLOCATIONName");
Label lblRECEIVERFname = (Label)e.Row.FindControl("lblRECEIVERFname");
FOODITEM_MASTER foodItems = new FOODITEM_MASTER();
foodItems = FOODITEM_MASTERManager.GetFOODITEM_MASTERByID(int.Parse(lblfID.Text));
if (Items != null)
{
lblFoodItem.Text = foodItems.ITEMNAME.ToString();
}
//lblSubTotal.Text = (decimal.Parse(lblfRATE.Text) * int.Parse(lblfQTY.Text)).ToString();
CUSTOMER cUSTOMER = new CUSTOMER();
cUSTOMER = CUSTOMERManager.GetCUSTOMERByID(int.Parse(lblCUSTID.Text));
if (cUSTOMER != null)
{
lblCUSTFname.Text = cUSTOMER.CUSTFNAME.ToString();
}
LOCATION lOCATION = new LOCATION();
lOCATION = LOCATIONManager.GetLOCATIONByID(int.Parse(lblLOCATIONID.Text));
if (lOCATION != null)
{
lblLOCATIONName.Text = lOCATION.BRANCH.ToString();
}
RECEIVER rECEIVER = new RECEIVER();
rECEIVER = RECEIVERManager.GetRECEIVERByID(int.Parse(lblRECEIVERID.Text));
if (rECEIVER != null)
{
lblRECEIVERFname.Text = rECEIVER.RECEIVERFNAME.ToString();
}
lblTOTALAMT.Text = lblTOTALAMT.Text;
}
}
public static FOODITEM_MASTER GetFOODITEM_MASTERByID(int id)
{
FOODITEM_MASTER fOODITEM_MASTER = new FOODITEM_MASTER();
SqlFOODITEM_MASTERProvider sqlFOODITEM_MASTERProvider = new SqlFOODITEM_MASTERProvider();
fOODITEM_MASTER = sqlFOODITEM_MASTERProvider.GetFOODITEM_MASTERByID(id);
return(fOODITEM_MASTER);
}
protected void ddlFoodItem_SelectedIndexChanged(object sender, EventArgs e)
{
FOODITEM_MASTER foodItem = new FOODITEM_MASTER();
foodItem = FOODITEM_MASTERManager.GetFOODITEM_MASTERByID(int.Parse(ddlFoodItem.SelectedItem.Value.ToString()));
if (foodItem != null)
{
txtFoodRate.Text = foodItem.RATE.ToString();
}
txtFoodQuantity.Text = "1";
}
private void showFOODITEM_MASTERData()
{
FOODITEM_MASTER fOODITEM_MASTER = new FOODITEM_MASTER();
fOODITEM_MASTER = FOODITEM_MASTERManager.GetFOODITEM_MASTERByID(Int32.Parse(Request.QueryString["fOODITEM_MASTERID"]));
txtITEMCODE.Text = fOODITEM_MASTER.ITEMCODE;
txtITEMNAME.Text = fOODITEM_MASTER.ITEMNAME;
txtRATE.Text = fOODITEM_MASTER.RATE.ToString();
ddlLocation.SelectedValue = fOODITEM_MASTER.SEQ.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
FOODITEM_MASTER fOODITEM_MASTER = new FOODITEM_MASTER();
fOODITEM_MASTER.ITEMCODE = txtITEMCODE.Text;
fOODITEM_MASTER.ITEMNAME = txtITEMNAME.Text;
fOODITEM_MASTER.RATE = decimal.Parse(txtRATE.Text);
fOODITEM_MASTER.AGENTID = 4;
fOODITEM_MASTER.SEQ = Int32.Parse(ddlLocation.SelectedValue);
int resutl = FOODITEM_MASTERManager.InsertFOODITEM_MASTER(fOODITEM_MASTER);
Response.Redirect("AdminFOODITEM_MASTERDisplay.aspx");
}
public bool UpdateFOODITEM_MASTER(FOODITEM_MASTER fOODITEM_MASTER)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateFOODITEM_MASTER", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FOODITEM_MASTERID", SqlDbType.Int).Value = fOODITEM_MASTER.FOODITEM_MASTERID;
cmd.Parameters.Add("@ITEMCODE", SqlDbType.VarChar).Value = fOODITEM_MASTER.ITEMCODE;
cmd.Parameters.Add("@ITEMNAME", SqlDbType.VarChar).Value = fOODITEM_MASTER.ITEMNAME;
cmd.Parameters.Add("@RATE", SqlDbType.Decimal).Value = fOODITEM_MASTER.RATE;
cmd.Parameters.Add("@AGENTID", SqlDbType.Int).Value = fOODITEM_MASTER.AGENTID;
cmd.Parameters.Add("@SEQ", SqlDbType.Int).Value = fOODITEM_MASTER.SEQ;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
FOODITEM_MASTER fOODITEM_MASTER = new FOODITEM_MASTER();
fOODITEM_MASTER = FOODITEM_MASTERManager.GetFOODITEM_MASTERByID(Int32.Parse(Request.QueryString["fOODITEM_MASTERID"]));
FOODITEM_MASTER tempFOODITEM_MASTER = new FOODITEM_MASTER();
tempFOODITEM_MASTER.FOODITEM_MASTERID = fOODITEM_MASTER.FOODITEM_MASTERID;
tempFOODITEM_MASTER.ITEMCODE = txtITEMCODE.Text;
tempFOODITEM_MASTER.ITEMNAME = txtITEMNAME.Text;
tempFOODITEM_MASTER.RATE = decimal.Parse(txtRATE.Text);
tempFOODITEM_MASTER.AGENTID = 4;
tempFOODITEM_MASTER.SEQ = Int32.Parse(ddlLocation.SelectedValue);
bool result = FOODITEM_MASTERManager.UpdateFOODITEM_MASTER(tempFOODITEM_MASTER);
Response.Redirect("AdminFOODITEM_MASTERDisplay.aspx");
}
public FOODITEM_MASTER GetFOODITEM_MASTERFromReader(IDataReader reader)
{
try
{
FOODITEM_MASTER fOODITEM_MASTER = new FOODITEM_MASTER
(
(int)reader["FOODITEM_MASTERID"],
reader["ITEMCODE"].ToString(),
reader["ITEMNAME"].ToString(),
(decimal)reader["RATE"],
(int)reader["AGENTID"],
(int)reader["SEQ"]
);
return(fOODITEM_MASTER);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateFOODITEM_MASTER(FOODITEM_MASTER fOODITEM_MASTER)
{
SqlFOODITEM_MASTERProvider sqlFOODITEM_MASTERProvider = new SqlFOODITEM_MASTERProvider();
return(sqlFOODITEM_MASTERProvider.UpdateFOODITEM_MASTER(fOODITEM_MASTER));
}
public static int InsertFOODITEM_MASTER(FOODITEM_MASTER fOODITEM_MASTER)
{
SqlFOODITEM_MASTERProvider sqlFOODITEM_MASTERProvider = new SqlFOODITEM_MASTERProvider();
return(sqlFOODITEM_MASTERProvider.InsertFOODITEM_MASTER(fOODITEM_MASTER));
}
