protected void btnSave_Click(object sender, EventArgs e)
{
if (Convert.ToBoolean(Session["ComputeClick"]) == true)
{
foreach (GridViewRow row in gvItems.Rows)
{
var objPODetail = new PO_Detail_Model
{
idPODetail = int.Parse(row.Cells[0].Text),
idPOHeader = int.Parse(row.Cells[1].Text),
idItem = int.Parse(row.Cells[2].Text),
Quantity = decimal.Parse(row.Cells[5].Text),
Price = decimal.Parse(row.Cells[6].Text),
Tax = decimal.Parse(row.Cells[7].Text),
Amount = decimal.Parse(row.Cells[8].Text),
Final_Cost = decimal.Parse(row.Cells[9].Text),
Unit_Comp = row.Cells[10].Text,
isReceived = "No",
Partial_Remaining = 0
};
PO_Detail.Update(oCon, objPODetail);
}
var pO_Charges_Model = new PO_Charges_Model
{
idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString()),
Brokerage = Convert.ToDecimal(txtBrokerage.Text),
CEDEC = Convert.ToDecimal(txtCEDEC.Text),
CustomsStamps = Convert.ToDecimal(txtCustomsStamps.Text),
DeliveryCharges = Convert.ToDecimal(txtDeliveryCharges.Text),
DocumentaryStamps = Convert.ToDecimal(txtDocumentaryStamps.Text),
DocumentationCharges = Convert.ToDecimal(txtDocumentationCharges.Text),
ForkliftCost = Convert.ToDecimal(txtForkliftCost.Text),
FreightCharges = Convert.ToDecimal(txtFreightCharges.Text),
HandlingFee = Convert.ToDecimal(txtHandlingFee.Text),
ImportationInsurance = Convert.ToDecimal(txtImportationInsurance.Text),
ImportDuties = Convert.ToDecimal(txtImportDuties.Text),
ImportProcessingFee = Convert.ToDecimal(txtImportProcessingFee.Text),
Miscellaneous = Convert.ToDecimal(txtMiscellaneous.Text),
NotarialFee = Convert.ToDecimal(txtNotarialFee.Text),
OtherCharges = Convert.ToDecimal(txtOtherCharges.Text),
ProcessingFee = Convert.ToDecimal(txtProcessingFee.Text),
WarehouseStorageCharges = Convert.ToDecimal(txtWarehouseStorageCharges.Text),
Xerox = Convert.ToDecimal(txtXerox.Text)
};
PO_Charges.Save(oCon, pO_Charges_Model);
var poheader = new PO_Header_Model
{
idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString()),
POStatus = "Announced",
Total_Charges = Convert.ToDecimal(txtTotalCharges.Text),
ImportShipmentNumber = txtImpShpNum.Text
};
PO_Header.UpdatePOStatus(oCon, poheader);
PO_Header.UpdateTotalCharges(oCon, poheader);
defaultSettings();
GetPO();
}
else
{
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Cost not yet computed!" + ControlChars.Quote + ");</script>");
}
}
public static bool Update(SqlConnection connection, PO_Detail_Model model)
{
bool returnValue = true;
var GUID = SQL_Transact.GenerateGUID();
SQL_Transact.BeginTransaction(connection, GUID);
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"UPDATE a_PO_Detail SET
idPOHeader = @idPOHeader
,idItem = @idItem
,Quantity = @Quantity
,Price = @Price
,Tax = @Tax
,Amount = @Amount
,Final_Cost = @Final_Cost
,Unit_Comp = @Unit_Comp
,isReceived = @isReceived
,Partial_Remaining = @Partial_Remaining
WHERE idPODetail = @idPODetail ");
using (SqlCommand cmd = new SqlCommand())
{
try
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm1 = new SqlParameter
{
ParameterName = "@idPODetail",
SqlDbType = SqlDbType.Int,
Value = model.idPODetail
};
cmd.Parameters.Add(parm1);
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@idPOHeader",
SqlDbType = SqlDbType.Int,
Value = model.idPOHeader
};
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter
{
ParameterName = "@Price",
SqlDbType = SqlDbType.Decimal,
Value = model.Price
};
cmd.Parameters.Add(parm3);
SqlParameter parm4 = new SqlParameter
{
ParameterName = "@idItem",
SqlDbType = SqlDbType.Int,
Value = model.idItem
};
cmd.Parameters.Add(parm4);
SqlParameter parm5 = new SqlParameter
{
ParameterName = "@isReceived",
SqlDbType = SqlDbType.NVarChar,
Value = model.isReceived
};
cmd.Parameters.Add(parm5);
SqlParameter parm6 = new SqlParameter
{
ParameterName = "@Quantity",
SqlDbType = SqlDbType.Decimal,
Value = model.Quantity
};
cmd.Parameters.Add(parm6);
SqlParameter parm7 = new SqlParameter
{
ParameterName = "@Unit_Comp",
SqlDbType = SqlDbType.NVarChar,
Value = model.Unit_Comp
};
cmd.Parameters.Add(parm7);
SqlParameter parm8 = new SqlParameter
{
ParameterName = "@Tax",
SqlDbType = SqlDbType.Decimal,
Value = model.Tax
};
cmd.Parameters.Add(parm8);
SqlParameter parm9 = new SqlParameter
{
ParameterName = "@Amount",
SqlDbType = SqlDbType.Decimal,
Value = model.Amount
};
cmd.Parameters.Add(parm9);
SqlParameter parm10 = new SqlParameter
{
ParameterName = "@Final_Cost",
SqlDbType = SqlDbType.Decimal,
Value = model.Final_Cost
};
cmd.Parameters.Add(parm10);
SqlParameter parm11 = new SqlParameter
{
ParameterName = "@Partial_Remaining",
SqlDbType = SqlDbType.Decimal,
Value = model.Partial_Remaining
};
cmd.Parameters.Add(parm11);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.CommitTransaction(connection, GUID);
}
}
catch
{
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.RollbackTransaction(connection, GUID);
}
}
return(returnValue);
}
public static bool UpdateReceivedStatus(SqlConnection connection, PO_Detail_Model model)
{
bool returnValue = true;
var GUID = SQL_Transact.GenerateGUID();
SQL_Transact.BeginTransaction(connection, GUID);
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"UPDATE a_PO_Detail SET
isReceived = @isReceived
,Partial_Remaining = @Partial_Remaining
WHERE idPODetail = @idPODetail ");
using (SqlCommand cmd = new SqlCommand())
{
try
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@idPODetail",
SqlDbType = SqlDbType.Int,
Value = model.idPODetail
};
cmd.Parameters.Add(parm2);
SqlParameter parm17 = new SqlParameter
{
ParameterName = "@isReceived",
SqlDbType = SqlDbType.NVarChar,
Value = model.isReceived
};
cmd.Parameters.Add(parm17);
SqlParameter parm11 = new SqlParameter
{
ParameterName = "@Partial_Remaining",
SqlDbType = SqlDbType.Decimal,
Value = model.Partial_Remaining
};
cmd.Parameters.Add(parm11);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.CommitTransaction(connection, GUID);
}
}
catch
{
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.RollbackTransaction(connection, GUID);
}
}
return(returnValue);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["Mode"].ToString() == "Add")
{
string PONum = PO_Header.GetLastPONumber(oCon);
if (PONum == null)
{
PONum = "PJ000000";
}
PONum = PONum.Substring(2);
int PONum_ = int.Parse(PONum) + 1;
string po_number = "PJ" + PONum_.ToString("000000");
var poHeader = new PO_Header_Model
{
PO_Number = po_number,
PO_Date = DateTime.Now,
Delivery_Date = DateTime.Now,
Terms = txtTerms.Text,
FOB_Point = "",
Shipping_Via = "",
Currency = "USD",
idSupplier = 0,
PO_Total = Convert.ToDecimal(txtPOAmount.Text),
PO_Quantity = Convert.ToInt32(txtPOQuantity.Text),
Total_Charges = 0,
Forex_Rate = Convert.ToDecimal(txtForexRate.Text),
PR_Number = "",
Created_By = Session["User_Domain"].ToString(),
Remarks = txtRemarks.Text,
POStatus = "Created",
ImportShipmentNumber = ""
};
int idPOHeader = PO_Header.Save(oCon, poHeader);
foreach (GridViewRow row in gvItems.Rows)
{
int idItem = int.Parse(row.Cells[1].Text);
decimal Quantity = decimal.Parse(row.Cells[4].Text);
decimal Price = decimal.Parse(row.Cells[5].Text);
decimal Extended = decimal.Parse(row.Cells[6].Text);
var objPODetail = new PO_Detail_Model
{
idPOHeader = idPOHeader,
idItem = idItem,
Quantity = Quantity,
Price = Price,
Amount = Extended,
Tax = 0,
Final_Cost = 0,
Unit_Comp = "",
isReceived = "No",
Partial_Remaining = 0
};
PO_Detail.Save(oCon, objPODetail);
}
POUpload(po_number, idPOHeader);
}
else if (Session["Mode"].ToString() == "Edit")
{
int idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString());
var poHeader = new PO_Header_Model
{
PO_Number = lblPONumber.Text,
Terms = txtTerms.Text,
FOB_Point = "",
Shipping_Via = "",
Currency = "USD",
idSupplier = 0,
PO_Total = Convert.ToDecimal(txtPOAmount.Text),
PO_Quantity = Convert.ToInt32(txtPOQuantity.Text),
Total_Charges = 0,
Forex_Rate = Convert.ToDecimal(txtForexRate.Text),
Created_By = Session["User_Domain"].ToString(),
Remarks = txtRemarks.Text,
POStatus = "Created",
idPOHeader = idPOHeader,
ImportShipmentNumber = ""
};
PO_Header.Update(oCon, poHeader);
bool result = PO_Detail.DeleteAllDetail(oCon, idPOHeader);
if (result == true)
{
foreach (GridViewRow row in gvItems.Rows)
{
int idItem = int.Parse(row.Cells[1].Text);
decimal Quantity = decimal.Parse(row.Cells[4].Text);
decimal Price = decimal.Parse(row.Cells[5].Text);
decimal Extended = decimal.Parse(row.Cells[6].Text);
var objPODetail = new PO_Detail_Model
{
idPOHeader = idPOHeader,
idItem = idItem,
Quantity = Quantity,
Price = Price,
Amount = Extended,
Tax = 0,
Final_Cost = 0,
Unit_Comp = "",
isReceived = "No",
Partial_Remaining = 0
};
PO_Detail.Save(oCon, objPODetail);
}
POUpload(lblPONumber.Text, idPOHeader);
}
else
{
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Error in deleting po detail of " + lblPONumber.Text + ControlChars.Quote + ");</script>");
}
}
defaultSettings();
GetPO();
}
