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));
}
