public List <SelectListItem> Consumables() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = "select ID,Code,Description,Specification, Applicationcenter_CostCenter from LKP_Consumable order by Description asc"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["Description"].ToString().Trim(), Value = sdr["ID"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> FeasibilityMaterialGrade() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = "select Srno,Materialgrade from LKP_Colorcode_Tb order by Materialgrade asc"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["Materialgrade"].ToString().Trim(), Value = sdr["Srno"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> CuutingCalculation() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = " SELECT xsection,id FROM LKP_CuutingCalculation_Tb"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["xsection"].ToString().Trim(), Value = sdr["id"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> DailyConsumables() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = " select ID,ConsumableName from LKP_ConsumableRatePerUnit where Type='dailyconsumptions' "; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["ConsumableName"].ToString().Trim(), Value = sdr["ID"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <ssmtbl_Feasibility_MultiVendorModel> FeasibilityRMVendors() { List <ssmtbl_Feasibility_MultiVendorModel> objList = new List <ssmtbl_Feasibility_MultiVendorModel>(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "uspGetVendorByVType"; SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_Feasibility_MultiVendorModel { VendorID = Convert.ToInt32(sdr["VendorID"].ToString().Trim()), VendorName = sdr["VendorName"].ToString().Trim(), auto_id = Convert.ToInt32(sdr["auto_id"].ToString().Trim()) }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> DieNumber() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = "select * from DieDescription"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["DieNo"].ToString().Trim(), Value = sdr["Id"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public static List <ssmtbl_LKP_TermsAndConditionModel> GetLKP_VPOTermsAndCondition() { List <ssmtbl_LKP_TermsAndConditionModel> objList = new List <ssmtbl_LKP_TermsAndConditionModel>(); try { string sqlstr = "SELECT * FROM LKPVPOTermandCondition"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_LKP_TermsAndConditionModel { id = Convert.ToInt32(sdr["Id"].ToString().Trim()), description = sdr["Termandcondition"].ToString().Trim(), }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <ssmtbl_Feasibility_OperationsInvolvedModel> FeasibilityOperationsInvolved() { List <ssmtbl_Feasibility_OperationsInvolvedModel> objList = new List <ssmtbl_Feasibility_OperationsInvolvedModel>(); try { //string sqlstr = "select Isnull(ID,0) As ID, Isnull(Options,'') As Options from LKP_Inquiry_Tb where Type='Operation involved' "; string sqlstr = "select Isnull(ID,0) As ID,Isnull(operationinvolvedname,'') As operationinvolvedname ,Isnull(seqforfeasoperationinvolved,'') As seqforfeasoperationinvolved from [LKP_Quotationoperationinvolved] where type='Quotation'order by seqforfeasoperationinvolved"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_Feasibility_OperationsInvolvedModel { Operations_Involved = Convert.ToInt32(sdr["ID"].ToString().Trim()), Operations_Involved_Text = sdr["operationinvolvedname"].ToString().Trim() }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public static List <ssmtbl_LKP_TermsAndConditionModel> GetLKP_VPOTermsAndConditionEdit(string vpono) { List <ssmtbl_LKP_TermsAndConditionModel> objList = new List <ssmtbl_LKP_TermsAndConditionModel>(); try { string sqlstr = "SELECT * FROM ssmtbl_VendorPurchaseOrderTermsNCondtion where po_no=@po_no"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@po_no", vpono.Trim()); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_LKP_TermsAndConditionModel { id = Convert.ToInt32(sdr["TermsNConditionID"].ToString().Trim()), description = sdr["TermsNConditionContent"].ToString().Trim(), flag = Convert.ToBoolean(sdr["flag"]), }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <ssmtbl_Feasibility_RawMaterialTestModel> FeasibilityRawMaterial() { List <ssmtbl_Feasibility_RawMaterialTestModel> objList = new List <ssmtbl_Feasibility_RawMaterialTestModel>(); try { string sqlstr = "select Isnull(id,0) as id,Isnull(type,'') as type from LKP_RawMaterialTestFis"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_Feasibility_RawMaterialTestModel { Raw_Material_Test = Convert.ToInt32(sdr["id"].ToString().Trim()), Raw_Material_Test_Text = sdr["type"].ToString().Trim() }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public static List <ssmtbl_LKP_TermsAndConditionModel> GetLKP_QuotaionTermsAndCondition(long inqno) { List <ssmtbl_LKP_TermsAndConditionModel> objList = new List <ssmtbl_LKP_TermsAndConditionModel>(); try { string sqlstr = "SELECT * FROM ssmtbl_TermsNCondtion where InquiryNo=@InquiryNo"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@InquiryNo", inqno); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new ssmtbl_LKP_TermsAndConditionModel { id = Convert.ToInt32(sdr["id"].ToString().Trim()), description = sdr["TermsNConditionContent"].ToString().Trim(), flag = Convert.ToBoolean(sdr["flag"].ToString()) }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> FrqRepOrder() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = " select ID,Options from LKP_Inquiry_Tb where Type='frqreporder' "; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["Options"].ToString().Trim(), Value = sdr["ID"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <VendorTypeList> VendorTypeList() { List <VendorTypeList> objList = new List <VendorTypeList>(); try { //string sqlstr = "select Isnull(ID,0) As ID, Isnull(Options,'') As Options from LKP_Inquiry_Tb where Type='Operation involved' "; string sqlstr = "select * from Lkp_VPOType order by Id"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objList.Add(new VendorTypeList { Id = Convert.ToInt32(sdr["Id"].ToString().Trim()), Type = sdr["Type"].ToString().Trim() }); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> VPOType() { List <SelectListItem> objList = new List <SelectListItem>(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "uspBindVPOType"; SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["Type"].ToString().Trim(), Value = sdr["Id"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> GetCostCenter() { List <SelectListItem> objList = new List <SelectListItem>(); try { string sqlstr = " select code,name from LKP_CostCenter "; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { SelectListItem sli = new SelectListItem { Text = sdr["code"].ToString().Trim() + "-" + sdr["name"].ToString().Trim(), Value = sdr["code"].ToString().Trim() }; objList.Add(sli); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public static List <ssmtbl_LKP_TermsAndConditionModel> GetSelectedQuotaionTermsAndCondition(long QuotationID) { List <ssmtbl_LKP_TermsAndConditionModel> objList = new List <ssmtbl_LKP_TermsAndConditionModel>(); try { string sqlstr = "SELECT ssmtbl_TermsNCondtion.TermsNConditionContent, ssmtbl_TermsNCondtion.TermsNConditionID, ssmtbl_TermsNCondtion.QuotationID, " + " LKP_TermsAndCondition.id,LKP_TermsAndCondition.description" + " FROM LKP_TermsAndCondition LEFT OUTER JOIN" + " ssmtbl_TermsNCondtion ON LKP_TermsAndCondition.id = ssmtbl_TermsNCondtion.TermsNConditionID AND ssmtbl_TermsNCondtion.QuotationID = @QuotationID"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@QuotationID", QuotationID); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_LKP_TermsAndConditionModel obj = new ssmtbl_LKP_TermsAndConditionModel(); obj.id = Convert.ToInt32(sdr["id"].ToString().Trim()); if (sdr["TermsNConditionID"].ToString() == sdr["id"].ToString()) { obj.flag = true; obj.description = sdr["TermsNConditionContent"].ToString().Trim(); } else { obj.description = sdr["description"].ToString().Trim(); } objList.Add(obj); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> GetGoodsInwardTypeList() { List <SelectListItem> objList = new List <SelectListItem>(); try { SelectListItem sli = new SelectListItem { Text = "Consumables", Value = "Consumables" }; objList.Add(sli); sli = new SelectListItem { Text = "Raw Material", Value = "Raw Material" }; objList.Add(sli); sli = new SelectListItem { Text = "Maintainance Spares", Value = "Maintainance Spares" }; objList.Add(sli); sli = new SelectListItem { Text = "Outsourcing", Value = "Outsourcing" }; objList.Add(sli); sli = new SelectListItem { Text = "Repair", Value = "Repair" }; objList.Add(sli); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> GetNotAvailableList() { List <SelectListItem> objList = new List <SelectListItem>(); try { SelectListItem sli = new SelectListItem { Text = "NA", Value = "NA" }; objList.Add(sli); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> GetDeliveryChallanTypeList() { List <SelectListItem> objList = new List <SelectListItem>(); try { SelectListItem sli = new SelectListItem { Text = "Job Dispatch", Value = "Job Dispatch" }; objList.Add(sli); sli = new SelectListItem { Text = "Outsourcing", Value = "Outsourcing" }; objList.Add(sli); sli = new SelectListItem { Text = "Lab Testing", Value = "Lab Testing" }; objList.Add(sli); sli = new SelectListItem { Text = "Repair", Value = "Repair" }; objList.Add(sli); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }
public List <SelectListItem> GetRatePerList() { List <SelectListItem> objList = new List <SelectListItem>(); try { SelectListItem sli = new SelectListItem { Text = "Rate/MT", Value = "Rate/MT" }; objList.Add(sli); sli = new SelectListItem { Text = "Rate/KG", Value = "Rate/KG" }; objList.Add(sli); sli = new SelectListItem { Text = "Rate/Liter", Value = "Rate/Liter" }; objList.Add(sli); sli = new SelectListItem { Text = "Rate/Piece", Value = "Rate/Piece" }; objList.Add(sli); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objList); }