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