public string PURC_Update_Config_DAL(POConfig POconfig, DataTable ConfigPOTable) { SqlParameter[] prm = new SqlParameter[] { new SqlParameter("@id", POconfig.ID), new SqlParameter("@PO_Type", POconfig.POType), new SqlParameter("@Auto_Owner_Selection", POconfig.Owner), new SqlParameter("@Delivery_Port", POconfig.Delivery_Port), new SqlParameter("@Delivery_Date", POconfig.Delivery_Port_date), new SqlParameter("@Vessel_Movement_Date", POconfig.Vessel_movement_Date), new SqlParameter("@Item_Category", POconfig.Item_Category), new SqlParameter("@Direct_Quotation", POconfig.Quote_required), new SqlParameter("@Min_QTN_Required", POconfig.QuoteNo), new SqlParameter("@Vessel_Processing_PO", POconfig.Vessel_Processing_PO), new SqlParameter("@Free_Text_Items_Addition", POconfig.Enable_Free_text), new SqlParameter("@Copy_To_Vessel", POconfig.copy_to_vessel), new SqlParameter("@Supplier_PO_Confirmation", POconfig.Sup_Po_Confirmation), new SqlParameter("@Vessel_Delivery_Confirmation", POconfig.Vessel_Delivery_Confirm), new SqlParameter("@Office_Delivery_Confirmation", POconfig.Office_Delivery_Confirmation), new SqlParameter("@Witholding_Tax", POconfig.Withhold_tax), new SqlParameter("@VAT_Config_By_Purchaser", POconfig.Vat_Config_Purc), new SqlParameter("@Verification_Required", POconfig.require_verify), new SqlParameter("@Auto_PO_Closing", POconfig.Auto_POClosing), new SqlParameter("@Currentuser", POconfig.Currentuser), new SqlParameter("@ConfigPOTable", ConfigPOTable), new SqlParameter("@Result", SqlDbType.VarChar) }; prm[prm.Length - 1].Direction = ParameterDirection.Input; SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "PURC_UPD_POConfig", prm); return(prm[prm.Length - 1].Value.ToString()); }
protected void deleteClick(object sender, ImageClickEventArgs e) { ImageButton im = (ImageButton)sender; POConfig POconfig = new POConfig(); POconfig.ID = im.CommandArgument.ToString(); POconfig.Currentuser = Session["userid"].ToString(); int count = objBLLconfig.PURC_Delete_Config_BLL(POconfig); string script = "<script type=\"text/javascript\">alert('" + POconfig.POType + " Mandatary Feilds Deleted !');</script>"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script); BindPOGrid(); }
public int PURC_Delete_Config_DAL(POConfig POconfig) { try { System.Data.SqlClient.SqlParameter[] sqlpram = new System.Data.SqlClient.SqlParameter[] { new SqlParameter("@ID", POconfig.ID), new SqlParameter("@DELETED_BY", POconfig.Currentuser) }; SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_DEL_POConfig]", sqlpram); return(0); } catch (Exception ex) { throw ex; } }
public int PURC_Delete_Config_BLL(POConfig POconfig) { return(purc_Config_DAL.PURC_Delete_Config_DAL(POconfig)); }
public string PURC_Save_Config__BLL(POConfig POconfig, DataTable ConfigPOTable) // Save PO Configuration { return(purc_Config_DAL.PURC_Save_Config_DAL(POconfig, ConfigPOTable)); }