//public List<ssmtbl_Feasibility_RawMaterialTestModel> GetFeasibilityRawMaterialByFeasId(int FeasibilityId)
//{
// List<ssmtbl_Feasibility_RawMaterialTestModel> objList = new List<ssmtbl_Feasibility_RawMaterialTestModel>();
// try
// {
// string sqlstr = " select FeasRaw.Raw_Material_Test, LkpRawTestFis.type "
// + " from ssmtbl_Feasibility Feas join ssmtbl_Feasibility_RawMaterialTest FeasRaw on Feas.FeasibilityId = FeasRaw.FeasibilityId "
// +" join LKP_RawMaterialTestFis LkpRawTestFis on FeasRaw.Raw_Material_Test = LkpRawTestFis.id "
// + " where Feas.FeasibilityId = @FeasibilityId ";
// var connection = gConnection.Connection();
// connection.Open();
// SqlCommand cmd = new SqlCommand(sqlstr, connection);
// cmd.Parameters.AddWithValue("@FeasibilityId", FeasibilityId);
// SqlDataReader sdr = cmd.ExecuteReader();
// while (sdr.Read())
// {
// objList.Add(new ssmtbl_Feasibility_RawMaterialTestModel
// {
// Raw_Material_Test = Convert.ToInt32(sdr["Raw_Material_Test"].ToString().Trim()),
// Raw_Material_Test_Text = sdr["type"].ToString().Trim()
// });
// }
// connection.Close();
// }
// catch (Exception ex)
// {
// ErrorHandlerClass.LogError(ex);
// }
// return objList;
//}
#endregion
#region Get Preffered Vendor
//var connection = gConnection.Connection();
//connection.Open();
// string sqlstr = "VendorPOType";
//SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Action", "select");
// cmd.Parameters.AddWithValue("@VendorId", id.Trim());
// SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//da.Fill(dt);
// DataRow[] dr = new DataRow[dt.Rows.Count];
//dt.Rows.CopyTo(dr, 0);
// int[] vtypeid = Array.ConvertAll(dr, new Converter<DataRow, int>(DataRowToDouble));
//connection.Close();
// //
// //int[] proinfo = new int [] { 1, 2 };
// ViewData["vtype"] = vtypeid;
public int[] GetRecommendedVendorByFeasId(int FeasibilityId)
{
//int[] objList = [];
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr1 = "uspInsertPrefferedVendor";
SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn);
cmd1.CommandType = System.Data.CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Action", "Select");
cmd1.Parameters.AddWithValue("@FeasiblityId", FeasibilityId);
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow[] dr = new DataRow[dt.Rows.Count];
dt.Rows.CopyTo(dr, 0);
int[] objList = Array.ConvertAll(dr, new Converter <DataRow, int>(DataRowToDouble));
connection.Close();
return(objList);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
public List <RMPlanningModel> GetAllRMPlanning()
{
List <RMPlanningModel> objRMList = new List <RMPlanningModel>();
try
{
string sqlstr = "ssmsp_Get_AllRMByGradeOfMaterial";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
RMPlanningModel objtemp = new RMPlanningModel();
objtemp.GradeOfMaterial = sdr["GradeOfMaterial"].ToString();
objtemp.HeatCode = sdr["HeatCode"].ToString();
objtemp.Section = sdr["Section"].ToString();
var qty = (sdr["Quntity"].ToString());
objtemp.Qty = qty == "" ? "0" : qty;
var Unit = sdr["RMUnit"].ToString();
objtemp.Unit = Unit == "" ? "NA" : Unit;
objRMList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objRMList);
}
public string ExecuteMail(EmailMessageInfo objMailModel, List <CargoRatesModel> objCRList)
{
string result = "Error on Sending Mail!";
try
{
var htmlData = getDataFromHtml(objCRList, objMailModel);
string Key = ConfigurationManager.AppSettings["SendGridApiKey"];
var apiKey = Environment.GetEnvironmentVariable(Key);
var client = new SendGridClient(Key);
var from = new EmailAddress(objMailModel.FromEmailAddress, objMailModel.FromName);
var subject = objMailModel.EmailSubject;
var to = new EmailAddress(objMailModel.ToEmailAddress, objMailModel.ToName);
var plainTextContent = "";
var htmlContent = htmlData;
var msg = MailHelper.CreateSingleEmail(from, to, subject, plainTextContent, htmlContent);
var response = client.SendEmailAsync(msg);
InsertQuotationData(objMailModel, objCRList);
result = "Mail Sent Successfully!";
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public List <SelectListItem> ListDeveloper()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "GetDevelopers";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["Name"].ToString();
tempobj.Value = sdr["EmpID"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <SelectListItem> ListProject()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "select ID as ProjectID, isnull(Project,'') as ProjectName from tbl_Projects order by ID";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["ProjectName"].ToString();
tempobj.Value = sdr["ProjectID"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <SelectListItem> ListCountry()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "select Id, isnull(Country,'') as Country from ACRF_Country order by Id";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["Country"].ToString();
tempobj.Value = sdr["Id"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <SelectListItem> ListEmail(int vendorId)
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "select Email, isnull(CustomerName,'') as CustomerName from ACRF_CustomerDetails where VendorId=@vendorId order by Email";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@vendorId", vendorId);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["CustomerName"].ToString();
tempobj.Value = sdr["Email"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public string SaveAddCuttingDetails(string cuttingID, string cutting1, string cutting2, string cutting3, string cutting4, string cutting5, string avg)
{
string result = "Error Inserting Cutting Details !";
try
{
string sqlstr = "uspCuttingSlip";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "InsertAddCuttingDetails");
cmd.Parameters.AddWithValue("@CuttingID", Convert.ToInt32(cuttingID));
cmd.Parameters.AddWithValue("@Cutting1", Convert.ToDecimal(cutting1));
cmd.Parameters.AddWithValue("@Cutting2", Convert.ToDecimal(cutting2));
cmd.Parameters.AddWithValue("@Cutting3", Convert.ToDecimal(cutting3));
cmd.Parameters.AddWithValue("@Cutting4", Convert.ToDecimal(cutting4));
cmd.Parameters.AddWithValue("@Cutting5", Convert.ToDecimal(cutting5));
cmd.Parameters.AddWithValue("@CuttingAvg", Convert.ToDecimal(avg));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
connection.Close();
List <Dictionary <string, object> > rfq = GetTableRows(dt);
result = "Cutting Details Inserted Successfully !";
return(result);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
public List <Dictionary <string, object> > GenerateCuttingSlip(string workorderNo, string quantity, string totalWeight, string ctSlipNo, string goodsIssuedno)
{
try
{
string sqlstr = "uspCuttingSlip";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Generate");
cmd.Parameters.AddWithValue("@workorderNo", workorderNo.Trim());
cmd.Parameters.AddWithValue("@quantity", float.Parse(quantity));
cmd.Parameters.AddWithValue("@totalWeight", float.Parse(totalWeight));
cmd.Parameters.AddWithValue("@ctSlipNo", ctSlipNo.Trim());
cmd.Parameters.AddWithValue("@goodsIssuedno", goodsIssuedno.Trim());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
connection.Close();
List <Dictionary <string, object> > rfq = GetTableRows(dt);
return(rfq);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
public ssmtbl_CustomerModel GetOneCustomer(int Id)
{
ssmtbl_CustomerModel objtemp = new ssmtbl_CustomerModel();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Get_AllVendor";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Id);
cmd.Parameters.AddWithValue("@Action", "GetCustomerByID");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objtemp.Name = sdr["Name"].ToString();
objtemp.Telephone_No = (sdr["Telephone_No"].ToString());
objtemp.GSTNo = (sdr["gst"].ToString());
objtemp.PANNo = (sdr["pan"].ToString());
objtemp.Remarks = sdr["Remarks"].ToString();
objtemp.Vendor_Code = sdr["Vendor_Code"].ToString();
objtemp.flag = Convert.ToBoolean(sdr["isActive"].ToString());
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objtemp);
}
public string CheckIfAirlinesExists(ACRF_AirlinesModel objModel)
{
string result = "";
try
{
string sqlstr = "Select * from ACRF_Airlines Where ISNULL(AirlineCode,'')=@AirlineCode and isnull(AirlineName,'')=@AirlineName "
+ " and isnull(SubCode,'') =@SubCode and Isnull(Id,0)!=@Id ";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@AirlineCode", objModel.AirlineCode);
cmd.Parameters.AddWithValue("@AirlineName", objModel.AirlineName);
cmd.Parameters.AddWithValue("@SubCode", objModel.SubCode);
cmd.Parameters.AddWithValue("@Id", objModel.Id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
result = "Airlines already exists!";
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public List <ssmtbl_CustomerModel> GetAllCustomer(string type)
{
List <ssmtbl_CustomerModel> objtempomerList = new List <ssmtbl_CustomerModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Get_AllVendor";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "selectcustomer");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_CustomerModel objtemp = new ssmtbl_CustomerModel();
//objtemp.SN = Convert.ToInt32(sdr["SN"].ToString());
objtemp.ID = Convert.ToInt32(sdr["ID"].ToString());
objtemp.Name = sdr["Name"].ToString();
objtemp.Address = (sdr["Address"].ToString());
objtemp.Telephone_No = (sdr["Telephone_No"].ToString());
objtempomerList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objtempomerList);
}
public static string GetCityNameFromCode(string code)
{
string result = "";
try
{
string sqlstr = "Select Isnull(CityCode,'') as CityCode,Isnull(CityName,'') as CityName From ACRF_DestinationMaster where CityCode=@CityCode";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@CityCode", code);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
result = sdr["CityName"].ToString();
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public string GenerateGoodsIssued(string gisId, string issuedWt, string remark, string goodsIssuedno)
{
string Result = "Error Issueing Goods !";
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "uspGoodsIssued";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Generate");
cmd.Parameters.AddWithValue("@IssuedWt", Convert.ToDouble(issuedWt));
cmd.Parameters.AddWithValue("@GoodsIssuedNo", goodsIssuedno.Trim());
cmd.Parameters.AddWithValue("@remark", remark.Trim());
cmd.Parameters.AddWithValue("@GoodsIssuedID", Convert.ToInt64(gisId));
SqlDataReader sdr = cmd.ExecuteReader();
connection.Close();
Result = "Goods Issued Successfully !";
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(Result);
}
public string CheckIfTariffModeExists(ACRF_TariffModeModel objModel)
{
string result = "";
try
{
string sqlstr = "Select * from ACRF_TariffMode Where ISNULL(TariffMode,'')=@TariffMode and Isnull(Id,0)!=@Id ";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@TariffMode", objModel.TariffMode);
cmd.Parameters.AddWithValue("@Id", objModel.Id);
SqlDataReader sdr = cmd.ExecuteReader();
if (objModel.TariffMode != "")
{
while (sdr.Read())
{
result = "Tariff Mode already exists!";
}
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public string GetMaxCuttingSlipNo()
{
string s = "CS-00001";
string csNo = "0";
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "uspCuttingSlip";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "SelectMaxCSNo");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
csNo = (sdr["CuttingSlipNo"].ToString());
s = csNo == "" ? "CS-00001" : ("CS-" + ((Convert.ToInt64(csNo.Split('-')[1]) + 1).ToString("00000")));
}
connection.Close();
}
catch (Exception ex)
{
s = "CS-00001";
ErrorHandlerClass.LogError(ex);
}
return(s);
}
public FileResult Export(string GridHtml)
{
var fpath = "";
try
{
using (MemoryStream stream = new System.IO.MemoryStream())
{
// fpath = HttpContext.Server.MapPath("~/PDFFiles/Quotation/");
StringReader sr = new StringReader(GridHtml);
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
iTextSharp.text.Image image1 = iTextSharp.text.Image.GetInstance(HttpContext.Server.MapPath("~/NewCssAndTheme/img/ssmlogo.jpg"));
image1.Alignment = iTextSharp.text.Image.ALIGN_CENTER;
image1.SetAbsolutePosition(20, 780);
image1.ScaleToFit(80f, 80f);
pdfDoc.Add(image1);
XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfDoc, sr);
pdfDoc.Close();
return(File(stream.ToArray(), "application/pdf", "Quotation.pdf"));
// return File(HttpContext.Server.MapPath("~/PDFFiles/Quotation/") , "application/pdf", "Grid.pdf");
}
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
public string updateReceivedQty(string cuttingID, string receivedQty, string receivedRemark)
{
string result = "";
try
{
string sqlstr = "uspCuttingSlip";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "UpdateReceivedQty");
cmd.Parameters.AddWithValue("@CuttingID", cuttingID.Trim());
cmd.Parameters.AddWithValue("@ReceivedQuantity", Convert.ToDecimal(receivedQty));
cmd.Parameters.AddWithValue("@ReceivedRemark", (receivedRemark).Trim());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
connection.Close();
List <Dictionary <string, object> > rfq = GetTableRows(dt);
return(result);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
public List <SelectListItem> ListCountryFromDestination()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "Select distinct CountryCode, CountryName From ACRF_DestinationMaster order by CountryName";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["CountryName"].ToString();
tempobj.Value = sdr["CountryCode"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <MonthlySale> GetMonthlySale(int VendorId)
{
List <MonthlySale> objList = new List <MonthlySale>();
try
{
string sqlstr = "Select sum(count) as count, mon + '-' + Convert(varchar(10),yyyy) as mon from "
+ " ACRFVW_GetLastTweleveMonthQuotationAmountWithStatus where VendorId in (0,@VendorId) "
+ " group by yyyy,mon,mon_number order by yyyy desc, mon_number desc";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@VendorId", VendorId);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
MonthlySale tempobj = new MonthlySale();
tempobj.MonthName = sdr["mon"].ToString();
tempobj.SaleAmount = Convert.ToDecimal(sdr["count"].ToString());
objList.Add(tempobj);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <SelectListItem> ListManager()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
string sqlstr = "select EmpID,ManagerName as Name from ProjectDetails pd inner join tbl_DCTEmployee de on pd.ManagerName=de.EmpName order by de.EmpID";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SelectListItem tempobj = new SelectListItem();
tempobj.Text = sdr["Name"].ToString();
tempobj.Value = sdr["EmpID"].ToString();
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public DisplayChart GetQuotationAmountForLastTweleveMonthsCompleted(int VendorId)
{
DisplayChart objModel = new DisplayChart();
try
{
List <string> CountList = new List <string>();
List <string> MonList = new List <string>();
string sqlstr = "Select sum(count) as count, ''''+mon+'''' as mon from ACRFVW_GetLastTweleveMonthQuotationAmountWithStatus "
+ " where VendorId in (0," + VendorId + ") and QuotationStatus in ('','" + QuotationType.Completed + "') group by yyyy,mon,mon_number order by mon_number";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
CountList.Add(sdr["count"].ToString());
MonList.Add(sdr["mon"].ToString());
}
connection.Close();
objModel.Count = CountList;
objModel.Text = MonList;
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objModel);
}
public List <SelectListItem> ListQuotationStatus()
{
List <SelectListItem> objList = new List <SelectListItem>();
try
{
objList.Add(new SelectListItem
{
Text = QuotationType.InProgress,
Value = QuotationType.InProgress
});
objList.Add(new SelectListItem
{
Text = QuotationType.OnHold,
Value = QuotationType.OnHold
});
objList.Add(new SelectListItem
{
Text = QuotationType.Completed,
Value = QuotationType.Completed
});
objList.Add(new SelectListItem
{
Text = QuotationType.Cancelled,
Value = QuotationType.Cancelled
});
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <ACRF_TariffModeModel> ListTariffMode()
{
List <ACRF_TariffModeModel> objList = new List <ACRF_TariffModeModel>();
try
{
string sqlstr = "select Id, isnull(TariffMode,'') as TariffMode, isnull(CreatedBy,'') as CreatedBy, isnull(createdon,'') as CreatedOn, "
+ " isnull(updatedby,'') as updatedby, isnull(updatedon,'') as updatedon from ACRF_TariffMode order by Id";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ACRF_TariffModeModel tempobj = new ACRF_TariffModeModel();
tempobj.Id = Convert.ToInt32(sdr["Id"].ToString());
tempobj.TariffMode = sdr["TariffMode"].ToString();
tempobj.CreatedBy = sdr["CreatedBy"].ToString();
tempobj.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public List <RMAllocationModel> GetAllRMPlanning(string quntity, string heatcode, string gradeOfMaterial, string section, string wono)
{
string result = "Error Updating RM Allocation";
List <RMAllocationModel> objRMAllocateList = new List <RMAllocationModel>();
try
{
string sqlstr = "ssmsp_Get_AllWorkorder";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "UpdateRmQty");
cmd.Parameters.AddWithValue("@quntity", quntity);
cmd.Parameters.AddWithValue("@Heatcode", heatcode);
cmd.Parameters.AddWithValue("@GradeOfMaterial", gradeOfMaterial);
cmd.Parameters.AddWithValue("@Section", section);
cmd.Parameters.AddWithValue("@WorkorderNo", wono);
SqlDataReader sdr = cmd.ExecuteReader();
connection.Close();
result = "RM Allocation updated successfully!";
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objRMAllocateList);
}
public ACRF_TariffModeModel GetOneTariffMode(int Id)
{
ACRF_TariffModeModel objList = new ACRF_TariffModeModel();
try
{
string sqlstr = "select Id, isnull(TariffMode,'') as TariffMode, isnull(CreatedBy,'') as CreatedBy, isnull(createdon,'') as CreatedOn, "
+ " isnull(updatedby,'') as updatedby, isnull(updatedon,'') as updatedon from ACRF_TariffMode where Id=@Id";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@Id", Id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objList.Id = Convert.ToInt32(sdr["Id"].ToString());
objList.TariffMode = sdr["TariffMode"].ToString();
objList.CreatedBy = sdr["CreatedBy"].ToString();
objList.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
//#region Get All RMAllocation
//public List<RMAllocationModel> GetAllRMAllocation()
//{
// List<RMAllocationModel> objRMAllocateList = new List<RMAllocationModel>();
// try
// {
// string sqlstr = "ssmsp_Get_AllWorkorder";
// var connection = gConnection.Connection();
// connection.Open();
// SqlCommand cmd = new SqlCommand(sqlstr, connection);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Action", "GetAllRMAllocation");
// SqlDataReader sdr = cmd.ExecuteReader();
// while (sdr.Read())
// {
// RMAllocationModel objtemp = new RMAllocationModel();
// objtemp.WorkorderNo = sdr["WorkorderNo"].ToString();
// objtemp.GradeOfMaterial = sdr["PoRM"].ToString();
// objtemp.HeatCode = sdr["HeatCode"].ToString();
// objtemp.Section = sdr["PoSection"].ToString();
// var qty = (sdr["AllocatedRMQty"].ToString());
// objtemp.Qty = qty == "" ? "0" : qty;
// objRMAllocateList.Add(objtemp);
// }
// connection.Close();
// }
// catch (Exception ex)
// {
// ErrorHandlerClass.LogError(ex);
// }
// return objRMAllocateList;
//}
//#endregion
#region Get All RMAllocation By Status
public List <RMAllocationModel> GetAllRMAllocation(int status)
{
List <RMAllocationModel> objRMAllocateList = new List <RMAllocationModel>();
try
{
string sqlstr = "ssmsp_Get_AllWorkorder";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "GetAllRMAllocationByStatus");
cmd.Parameters.AddWithValue("@Status", status);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
RMAllocationModel objtemp = new RMAllocationModel();
objtemp.WorkorderNo = sdr["WorkorderNo"].ToString();
objtemp.GradeOfMaterial = sdr["PoRM"].ToString();
objtemp.HeatCode = sdr["HeatCode"].ToString();
objtemp.Section = sdr["PoSection"].ToString();
var qty = (sdr["AllocatedRMQty"].ToString());
objtemp.Qty = qty == "" ? "0" : qty;
objRMAllocateList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objRMAllocateList);
}
public Paged_ACRF_TariffModeModel ListTariffMode(int max, int page, string search, string sort_col, string sort_dir)
{
Paged_ACRF_TariffModeModel objPaged = new Paged_ACRF_TariffModeModel();
List <ACRF_TariffModeModel> objList = new List <ACRF_TariffModeModel>();
try
{
if (search == null)
{
search = "";
}
int startIndex = max * (page - 1);
string sqlstr = "ACRF_GetTariffModeByPage";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@startRowIndex", startIndex);
cmd.Parameters.AddWithValue("@pageSize", max);
cmd.Parameters.AddWithValue("@search", search);
cmd.Parameters.AddWithValue("@sort_col", sort_col);
cmd.Parameters.AddWithValue("@sort_dir", sort_dir);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ACRF_TariffModeModel tempobj = new ACRF_TariffModeModel();
tempobj.Id = Convert.ToInt32(sdr["Id"].ToString());
tempobj.TariffMode = sdr["TariffMode"].ToString();
tempobj.CreatedBy = sdr["CreatedBy"].ToString();
tempobj.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
objList.Add(tempobj);
}
sdr.Close();
objPaged.ACRF_TariffModeModelList = objList;
sqlstr = "select count(*) as cnt from ACRF_TariffMode where TariffMode like @search ";
cmd.Parameters.Clear();
cmd.CommandText = sqlstr;
cmd.Connection = connection;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@search", '%' + @search + '%');
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objPaged.PageCount = Convert.ToInt32(sdr["cnt"].ToString());
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objPaged);
}
public List <ssmtbl_ConsumableModel> GetUnits(string startwith)
{
List <ssmtbl_ConsumableModel> objConsumablesList = new List <ssmtbl_ConsumableModel>();
try
{
string sqlstr = "ssmsp_Lkp_Consumables";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@startwith", startwith);
cmd.Parameters.AddWithValue("@Action", "bindUnits");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_ConsumableModel objtemp = new ssmtbl_ConsumableModel();
objtemp.Units = sdr["Units"].ToString();
objConsumablesList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objConsumablesList);
}
//public List<Dictionary<string, object>> GetOperationInvolvedByFeasId(int FeasibilityId)
//{
// List<Dictionary<string, object>> objList = new List<Dictionary<string, object>>();
// try
// {
// string sqlstr = "select FeasOps.Operations_Involved, LkpOpsInvovled.operationinvolvedname, LkpOpsInvovled.seqforfeasoperationinvolved "
// + " from ssmtbl_Feasibility Feas join ssmtbl_Feasibility_OperationsInvolved FeasOps on Feas.FeasibilityId = FeasOps.FeasibilityId "
// + " join LKP_Quotationoperationinvolved LkpOpsInvovled on FeasOps.Operations_Involved = LkpOpsInvovled.id "
// + " where type = 'Quotation'and Feas.FeasibilityId = @FeasibilityId order by seqforfeasoperationinvolved ";
// // 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);
// cmd.Parameters.AddWithValue("@FeasibilityId", FeasibilityId);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// DataTable dt = new DataTable();
// da.Fill(dt);
// connection.Close();
// objList = GetTableRows(dt);
// }
// catch (Exception ex)
// {
// ErrorHandlerClass.LogError(ex);
// }
// return objList;
//}
#endregion
#region Get RawMaterial Test
public int[] GetFeasibilityRawMaterialByFeasId(int FeasibilityId)
{
//int[] objList = [];
try
{
string sqlstr = " select FeasRaw.Raw_Material_Test, LkpRawTestFis.type "
+ " from ssmtbl_Feasibility Feas join ssmtbl_Feasibility_RawMaterialTest FeasRaw on Feas.FeasibilityId = FeasRaw.FeasibilityId "
+ " join LKP_RawMaterialTestFis LkpRawTestFis on FeasRaw.Raw_Material_Test = LkpRawTestFis.id "
+ " where Feas.FeasibilityId = @FeasibilityId ";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@FeasibilityId", FeasibilityId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow[] dr = new DataRow[dt.Rows.Count];
dt.Rows.CopyTo(dr, 0);
int[] objList = Array.ConvertAll(dr, new Converter <DataRow, int>(DataRowToDoubleRM));
connection.Close();
return(objList);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(null);
}
