protected void btnSave_Click(object sender, EventArgs e) { try { StringBuilder strQuery = new StringBuilder(); TechnicalBAL objTechBAL = new TechnicalBAL(); VsDtOrder = (DataTable)ViewState["VsDtOrder"]; int i = 0; string strReqCode = VsDtOrder.Rows[0]["Requisition"].ToString(); string strDocCode = VsDtOrder.Rows[0]["DOCUMENT_CODE"].ToString(); string strSuppCode = VsDtOrder.Rows[0]["QUOTATION_SUPPLIER"].ToString(); string strOrderCode = VsDtOrder.Rows[0]["ORDER_CODE"].ToString(); string strVesselCode = VsDtOrder.Rows[0]["Vessel_Code"].ToString(); string strCreatedBy = Session["userid"].ToString(); string strPayAt = "On Office"; decimal dclSuppOrdDiscount = Convert.ToDecimal(VsDtOrder.Rows[0]["suppOrderDiscount"].ToString()); decimal dclTotalPay = 0, dclRoundOffAmt = 0; if (txtAmount.Text.Trim() != "") { dclTotalPay = Convert.ToDecimal(txtAmount.Text.Trim().ToString()); } else { dclTotalPay = 0; } if (txtRoundoff.Text.Trim() != "") { dclRoundOffAmt = Convert.ToDecimal(txtRoundoff.Text.Trim().ToString()); } else { dclRoundOffAmt = 0; } string strSystemCode = VsDtOrder.Rows[0]["ITEM_SYSTEM_CODE"].ToString(); string strDeptCode = VsDtOrder.Rows[0]["DEPARTMENT"].ToString(); string strDeliverQty = "", strUpdateROBQty = "", strItemIDs = ""; foreach (GridDataItem dataItem in rgdDeliveredItems.MasterTableView.Items) { TextBox txtDeliverdQty = (TextBox)(dataItem.FindControl("txtDeliverdQty") as TextBox); Label txtUpdateROB = (Label)(dataItem.FindControl("txtUpdateROB") as Label); if (txtDeliverdQty.Text.Trim() != "") { strDeliverQty = strDeliverQty + txtDeliverdQty.Text.ToString() + ","; strUpdateROBQty = strUpdateROBQty + txtUpdateROB.Text.ToString() + ","; strItemIDs = strItemIDs + dataItem["ITEM_REF_CODE"].Text.ToString() + ","; i++; } } if (i == 0) { String msgNoItem = String.Format("alert('Please enter quantity for deliver.')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgNoItem", msgNoItem, true); lblError.Text = "Please enter quantity for deliver."; } else { int RetValue = objTechBAL.UpdateDelivery(strReqCode, strDocCode, strSuppCode, strOrderCode, strVesselCode, strCreatedBy, strPayAt, dclTotalPay, dclRoundOffAmt, strSystemCode, strDeptCode, strItemIDs, strDeliverQty, strUpdateROBQty, dclSuppOrdDiscount ); DataTable dtDeliverItem = (DataTable)ViewState["dtDeliverItem"]; foreach (DataRow dr in dtDeliverItem.Rows) { if (dr["ITEM_REF_CODE"].ToString() == "") { strQuery.Append("Insert into [PURC_Dtl_Supply_Items]([ID],ITEM_SYSTEM_CODE,[DOCUMENT_CODE],[ITEM_SERIAL_NO],[REQUISITION_CODE],"); strQuery.Append("[ORDER_CODE],[Order_Date],[REQUESTED_QTY],[ITEM_SHORT_DESC],[ORDER_QTY],[ORDER_SUPPLIER],[Vessel_Code],[Created_By],"); strQuery.Append("[Date_Of_Creatation],DELIVERY_CODE,ORDER_PRICE,ORDER_RATE,DELIVERD_QTY,Item_delivery_Remarks )"); strQuery.Append("(select Top 1 (select max([ID])+1 from [PURC_Dtl_Supply_Items]),ITEM_SYSTEM_CODE,[DOCUMENT_CODE],0,[REQUISITION_CODE],"); strQuery.Append("[ORDER_CODE],[Order_Date],1,'"); strQuery.Append(dr["Short_Description"].ToString()); strQuery.Append("',1,[ORDER_SUPPLIER],[Vessel_Code],[Created_By],[Date_Of_Creatation],DELIVERY_CODE,'"); strQuery.Append(dr["Rate"].ToString()); strQuery.Append("','"); strQuery.Append(dr["Rate"].ToString()); strQuery.Append("','1','" + Convert.ToString(dr["Item_delivery_Remarks"]) + "from [PURC_Dtl_Supply_Items]"); strQuery.Append(" where [REQUISITION_CODE]= '"); strQuery.Append(strReqCode); strQuery.Append("' and ORDER_CODE='"); strQuery.Append(strOrderCode); strQuery.Append("') "); } } int val = objTechBAL.ExecuteQuery(strQuery.ToString()); String msg = String.Format("alert('Delivered Items has been save successfully.')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); lblError.Text = "Delivered Items has been save successfully."; //cmbRequisitionList.SelectedIndex = 0; FillReq_Catalog(); BindOrderItem(); RefreshGrid(); using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { //Update the requistion Stage Status DataTable dtQuotationList = new DataTable(); dtQuotationList.Columns.Add("Qtncode"); dtQuotationList.Columns.Add("amount"); objTechService.InsertRequisitionStageStatus(Request.QueryString["Requisitioncode"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["Document_Code"].ToString(), "DLV", " ", Convert.ToInt32(Session["userid"]), dtQuotationList); } } } catch (Exception ex) { //.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex); } }