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