public FOODITEM_TRANSMASTER GetFOODITEM_TRANSMASTERForReportFromReader(IDataReader reader)
{
try
{
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER
(
(int)reader["FOODITEM_TRANSMASTERID"],
(DateTime)reader["TDATE"],
(int)reader["CID"],
(int)reader["LID"],
(int)reader["AID"],
(decimal)reader["TOTALAMT"],
reader["TRANSSTATUS"].ToString(),
reader["REFCODE"].ToString(),
(int)reader["RECID"],
(DateTime)reader["RECDATE"],
(int)reader["STOREID"],
(DateTime)reader["CREATEDON"],
(int)reader["CREATEDBY"],
(DateTime)reader["UPDATEDON"],
(int)reader["UPDATEDBY"],
reader["COUNTRY"].ToString(),
reader["CITY"].ToString(),
reader["BRANCH"].ToString(),
reader["BRANCH_CODE"].ToString(),
reader["CUSTOMERFULLNAME"].ToString(),
reader["RECEIVERFULLNAME"].ToString()
);
return(fOODITEM_TRANSMASTER);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateFOODITEM_TRANSMASTER(FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateFOODITEM_TRANSMASTER", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FOODITEM_TRANSMASTERID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
cmd.Parameters.Add("@TDATE", SqlDbType.DateTime).Value = fOODITEM_TRANSMASTER.TDATE;
cmd.Parameters.Add("@CID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.CID;
cmd.Parameters.Add("@LID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.LID;
cmd.Parameters.Add("@AID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.AID;
cmd.Parameters.Add("@TOTALAMT", SqlDbType.Decimal).Value = fOODITEM_TRANSMASTER.TOTALAMT;
cmd.Parameters.Add("@TRANSSTATUS", SqlDbType.VarChar).Value = fOODITEM_TRANSMASTER.TRANSSTATUS;
cmd.Parameters.Add("@REFCODE", SqlDbType.VarChar).Value = fOODITEM_TRANSMASTER.REFCODE;
cmd.Parameters.Add("@RECID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.RECID;
cmd.Parameters.Add("@RECDATE", SqlDbType.DateTime).Value = fOODITEM_TRANSMASTER.RECDATE;
cmd.Parameters.Add("@STOREID", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.STOREID;
cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = fOODITEM_TRANSMASTER.CREATEDON;
cmd.Parameters.Add("@CREATEDBY", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.CREATEDBY;
cmd.Parameters.Add("@UPDATEDON", SqlDbType.DateTime).Value = fOODITEM_TRANSMASTER.UPDATEDON;
cmd.Parameters.Add("@UPDATEDBY", SqlDbType.Int).Value = fOODITEM_TRANSMASTER.UPDATEDBY;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static FOODITEM_TRANSMASTER GetFOODITEM_TRANSMASTERByRefCode(string refCode)
{
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
SqlFOODITEM_TRANSMASTERProvider sqlFOODITEM_TRANSMASTERProvider = new SqlFOODITEM_TRANSMASTERProvider();
fOODITEM_TRANSMASTER = sqlFOODITEM_TRANSMASTERProvider.GetFOODITEM_TRANSMASTERByRefCode(refCode);
return(fOODITEM_TRANSMASTER);
}
public static FOODITEM_TRANSMASTER GetFOODITEM_TRANSMASTERByID(int id)
{
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
SqlFOODITEM_TRANSMASTERProvider sqlFOODITEM_TRANSMASTERProvider = new SqlFOODITEM_TRANSMASTERProvider();
fOODITEM_TRANSMASTER = sqlFOODITEM_TRANSMASTERProvider.GetFOODITEM_TRANSMASTERByID(id);
return(fOODITEM_TRANSMASTER);
}
protected void updateFoodItemMaster(string transStatus)
{
// FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
//fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(Int32.Parse(Request.QueryString["fOODITEM_TRANSMASTERID"]));
AGENT aGENT = (AGENT)Session["aGENT"];
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByRefCode(hfReferenceCode.Value);
FOODITEM_TRANSMASTER tempFOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
tempFOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
tempFOODITEM_TRANSMASTER.TDATE = fOODITEM_TRANSMASTER.TDATE;
tempFOODITEM_TRANSMASTER.CID = fOODITEM_TRANSMASTER.CID;
tempFOODITEM_TRANSMASTER.LID = fOODITEM_TRANSMASTER.LID;
tempFOODITEM_TRANSMASTER.AID = fOODITEM_TRANSMASTER.AID;
tempFOODITEM_TRANSMASTER.TOTALAMT = decimal.Parse(lblTotalAmount.Text);
if (transStatus == "SAME")
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = fOODITEM_TRANSMASTER.TRANSSTATUS;
}
else
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = transStatus;
}
tempFOODITEM_TRANSMASTER.REFCODE = fOODITEM_TRANSMASTER.REFCODE;
tempFOODITEM_TRANSMASTER.RECID = fOODITEM_TRANSMASTER.RECID;
tempFOODITEM_TRANSMASTER.RECDATE = fOODITEM_TRANSMASTER.RECDATE;
tempFOODITEM_TRANSMASTER.STOREID = fOODITEM_TRANSMASTER.STOREID;
tempFOODITEM_TRANSMASTER.CREATEDON = fOODITEM_TRANSMASTER.CREATEDON;
tempFOODITEM_TRANSMASTER.CREATEDBY = fOODITEM_TRANSMASTER.CREATEDBY;
tempFOODITEM_TRANSMASTER.UPDATEDON = DateTime.Now;
tempFOODITEM_TRANSMASTER.UPDATEDBY = aGENT.AGENTID;
bool result = FOODITEM_TRANSMASTERManager.UpdateFOODITEM_TRANSMASTER(tempFOODITEM_TRANSMASTER);
}
private void showFoodTRANSData(string refCode)
{
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByRefCode(refCode);
if (fOODITEM_TRANSMASTER == null)
{
panData.Visible = false;
panSearch.Visible = true;
}
else
{
panData.Visible = true;
panSearch.Visible = true;
int senderID = fOODITEM_TRANSMASTER.CID;
int receiverID = fOODITEM_TRANSMASTER.RECID;
int locationID = fOODITEM_TRANSMASTER.LID;
int fOODITEM_TRANSMASTERID = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
hfCUSTID.Value = senderID.ToString();
hfRECID.Value = receiverID.ToString();
hfFOODTRANSID.Value = fOODITEM_TRANSMASTERID.ToString();
loadSenderInfo(senderID);
loadReceiverInfo(receiverID);
loadLocation(locationID);
GetlocationInfo();
loadFoodItemGrid(fOODITEM_TRANSMASTERID);
CalculateTotalAmount();
}
}
public static bool UpdateFOODITEM_TRANSMASTER(FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER)
{
SqlFOODITEM_TRANSMASTERProvider sqlFOODITEM_TRANSMASTERProvider = new SqlFOODITEM_TRANSMASTERProvider();
return(sqlFOODITEM_TRANSMASTERProvider.UpdateFOODITEM_TRANSMASTER(fOODITEM_TRANSMASTER));
}
public static int InsertFOODITEM_TRANSMASTER(FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER)
{
SqlFOODITEM_TRANSMASTERProvider sqlFOODITEM_TRANSMASTERProvider = new SqlFOODITEM_TRANSMASTERProvider();
return(sqlFOODITEM_TRANSMASTERProvider.InsertFOODITEM_TRANSMASTER(fOODITEM_TRANSMASTER));
}
protected void btnSaveTransaction_Click(object sender, EventArgs e)
{
try
{
if (Session["sessionFOODITEM_TRANSMASTERDETAIL"] != null)
{
AGENT aGENT = (AGENT)Session["aGENT"];
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
List <FOODITEM_TRANSMASTERDETAIL> fOODITEM_TRANSMASTERDETAIL_Ori = new List <FOODITEM_TRANSMASTERDETAIL>();
fOODITEM_TRANSMASTERDETAIL_Ori = (List <FOODITEM_TRANSMASTERDETAIL>)Session["sessionFOODITEM_TRANSMASTERDETAIL"];
List <FOODITEM_TRANSMASTERDETAIL> fOODITEM_TRANSMASTERDETAIL_Distinct = new List <FOODITEM_TRANSMASTERDETAIL>();
int count = 0;
for (int i = 0; i < fOODITEM_TRANSMASTERDETAIL_Ori.Count; i++)
{
count = fOODITEM_TRANSMASTERDETAIL_Distinct.FindAll(x => x.CUSTID == fOODITEM_TRANSMASTERDETAIL_Ori[i].CUSTID && x.LOCATIONID == fOODITEM_TRANSMASTERDETAIL_Ori[i].LOCATIONID && x.RECEIVERID == fOODITEM_TRANSMASTERDETAIL_Ori[i].RECEIVERID).Count;
if (count == 0)
{
fOODITEM_TRANSMASTERDETAIL_Distinct.Add(fOODITEM_TRANSMASTERDETAIL_Ori[i]);
}
}
string refCode = string.Empty;
for (int j = 0; j < fOODITEM_TRANSMASTERDETAIL_Distinct.Count; j++)
{
#region FoodItemTransMaster
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER.TDATE = DateTime.Now;
fOODITEM_TRANSMASTER.CID = fOODITEM_TRANSMASTERDETAIL_Distinct[j].CUSTID;
fOODITEM_TRANSMASTER.LID = int.Parse(Session["snFoodlocationID"].ToString());
fOODITEM_TRANSMASTER.AID = aGENT.AGENTID;
//fOODITEM_TRANSMASTER.TOTALAMT = fOODITEM_TRANSMASTERDETAIL_Distinct[j].TOTALAMT;
fOODITEM_TRANSMASTER.TOTALAMT = decimal.Parse(lblTotalAmount.Text);
fOODITEM_TRANSMASTER.TRANSSTATUS = "PENDING";
fOODITEM_TRANSMASTER.REFCODE = txtReferenceCode.Text;
fOODITEM_TRANSMASTER.RECID = fOODITEM_TRANSMASTERDETAIL_Distinct[j].RECEIVERID;
fOODITEM_TRANSMASTER.RECDATE = nullDate;
fOODITEM_TRANSMASTER.STOREID = 1;
fOODITEM_TRANSMASTER.CREATEDON = DateTime.Now;
fOODITEM_TRANSMASTER.CREATEDBY = aGENT.AGENTID;
fOODITEM_TRANSMASTER.UPDATEDON = DateTime.Now;
fOODITEM_TRANSMASTER.UPDATEDBY = aGENT.AGENTID;
int resutlfOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.InsertFOODITEM_TRANSMASTER(fOODITEM_TRANSMASTER);
#endregion
FOODITEM_TRANSDETAIL fOODITEM_TRANSDETAIL = new FOODITEM_TRANSDETAIL();
for (int i = 0; i < gvFoodTransactionItemRelation.Rows.Count; i++)
{
Label lblfID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfID");
Label lblfRATE = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfRATE");
Label lblfQTY = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblfQTY");
Label lblCUSTID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblCUSTID");
Label lblLOCATIONID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblLOCATIONID");
Label lblRECEIVERID = (Label)gvFoodTransactionItemRelation.Rows[i].FindControl("lblRECEIVERID");
if (int.Parse(lblCUSTID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].CUSTID && int.Parse(lblLOCATIONID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].LOCATIONID && int.Parse(lblRECEIVERID.Text) == fOODITEM_TRANSMASTERDETAIL_Distinct[j].RECEIVERID)
{
fOODITEM_TRANSDETAIL.TID = resutlfOODITEM_TRANSMASTER;
fOODITEM_TRANSDETAIL.FID = Int32.Parse(lblfID.Text);
fOODITEM_TRANSDETAIL.FRATE = decimal.Parse(lblfRATE.Text);
fOODITEM_TRANSDETAIL.FQTY = Int32.Parse(lblfQTY.Text);
fOODITEM_TRANSDETAIL.CREATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.CREATEDBY = 1;
fOODITEM_TRANSDETAIL.UPDATEDON = DateTime.Now;
fOODITEM_TRANSDETAIL.UPDATEDBY = 1;
int resutl = FOODITEM_TRANSDETAILManager.InsertFOODITEM_TRANSDETAIL(fOODITEM_TRANSDETAIL);
}
}
lblReferenceCODE.Text = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(resutlfOODITEM_TRANSMASTER).REFCODE.ToString();// +"<br/>" + refCode.ToString();
refCode = lblReferenceCODE.Text;
}
//lblmessage.Text = resutlfOODITEM_TRANSMASTER.ToString();
lblmessage.Text = "Food Transfer Successfully.. ";
lblText.Text = "Reference CODE: ";
//lblReferenceCODE.Text= FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(resutlfOODITEM_TRANSMASTER).REFCODE ;
}
}
catch (Exception ex)
{
lblmessage.Text = ex.ToString();
}
}
