public string ExtractRARFile(string filePath, string UserID, int Fileid) { try { string[] FileDetail = filePath.ToString().Split(new string[] { "\\", ".rar" }, StringSplitOptions.RemoveEmptyEntries); string fileName = FileDetail[FileDetail.Length - 1]; string newPath = null; RarArchive file = RarArchive.Open(filePath); newPath = Path.Combine(Server.MapPath("~/Files"), fileName); using (DBClass context = new DBClass()) { context.AddParameter("@FileID", Fileid); context.AddParameter("@UserID", UserID); context.AddParameter("@FileName", fileName); context.AddParameter("@NewPath", newPath); context.ExecuteNonQuery("UpdateFileData", CommandType.StoredProcedure); } foreach (RarArchiveEntry rarFile in file.Entries) { rarFile.WriteToDirectory(newPath, ExtractOptions.ExtractFullPath); } //if(System.IO.File.Exists(filePath)) //{ // System.IO.File.Delete(filePath); //} return(newPath); } catch (Exception e) { throw e; } }
public ActionResult ChangeProfileImage() { HttpFileCollectionBase files = Request.Files; HttpPostedFileBase file = files[0]; string FileName = Session["UserName"].ToString() + "@" + file.FileName; string extension = file.FileName.Substring(file.FileName.LastIndexOf('.')); if (file.FileName != null || file.FileName != "") { string fname = Path.Combine(Server.MapPath("../Content/User Image/"), FileName); string filepath = "../Content/User Image/" + FileName; using (DBClass context = new DBClass()) { context.AddParameter("@UserName", Session["UserName"]); context.AddParameter("@UserRole", Session["UserRole"]); context.AddParameter("@Filepath", filepath); int i = context.ExecuteNonQuery("updateUserImage", CommandType.StoredProcedure); if (i > 0) { file.SaveAs(fname); } Session["ImagePath"] = filepath; //string imgpath = "../Content/User Image/" + FileName; //ViewData["ImagePath"] = imgpath; return(Json(new { status = "Success", path = filepath })); } } else { return(Json(new { status = "Failed", Message = "You have not selected any image !" })); } }
public ActionResult GetMachineData1(int fileID, UploadFile upl) { List <UploadFile> MachineData = new List <UploadFile>(); try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); context.AddParameter("@UserName", Session["UserName"].ToString()); DataTable dt = context.getData("getDriveUnit", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { string MacID = Convert.ToString(dr["ID"]); string Train = Convert.ToString(dr["MachineName"]); string DEUnit = Convert.ToString(dr["DUName"]); int PointCount = Convert.ToInt32(dr["Point_Count"]); MachineData.Add(new UploadFile { MachineID = Convert.ToInt32(MacID), TrainName = Convert.ToString(Train), DEUnitType = Convert.ToString(DEUnit), //NDEUnit1 = Convert.ToString(NDE1), //NDEUnit2 = Convert.ToString(NDE2), //NDEUnit3 = Convert.ToString(NDE3), TotalPoint = Convert.ToInt32(PointCount) }); } } } catch { } var machinedata = Json(MachineData, JsonRequestBehavior.AllowGet); return(machinedata); }
public JsonResult getDrivenUnit(string id) { //Preparing anonymous variable with json data List <UploadFile> MachineData = new List <UploadFile>(); try { using (DBClass context = new DBClass()) { context.AddParameter("@MachineID", id); context.AddParameter("@UserName", Session["UserName"].ToString()); DataTable dt = context.getData("getDrivenUnit", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { string MacID = Convert.ToString(dr["ID"]); string NDEName = Convert.ToString(dr["Machine_Name"]); int PointCount = Convert.ToInt32(dr["Point_Count"]); MachineData.Add(new UploadFile { MachineID = Convert.ToInt32(MacID), NDEUnit1 = Convert.ToString(NDEName), Point_Count_NDE = Convert.ToInt32(PointCount) }); } } } catch { } //Returning json data return(Json(MachineData, JsonRequestBehavior.AllowGet)); }
public ActionResult BoughtEnquiry(string Id) { using (DBClass context = new DBClass()) { var uname = Session["UserName"].ToString(); SessionClass.Username = uname; context.AddParameter("@Username", Session["UserName"].ToString()); DataSet ds = context.ExecuteDataSet("getUserRole", CommandType.StoredProcedure); if (Convert.ToString(ds.Tables[0].Rows[0]["UserRole"]) != "Client") { DataTable dt = new DataTable(); context.AddParameter("@UserName", Session["UserName"].ToString()); context.AddParameter("@EnquiryID", Convert.ToInt32(Id)); dt = context.getData("getExpertBalance", CommandType.StoredProcedure); //int CurrentBalance = Convert.ToInt32(dt.Rows[0]["Current_PointBalance"]); int enquiryCost = Convert.ToInt32(dt.Rows[0]["Enquiry_Cost"]); return(Json(new { status = "Success", message = "hello !" })); } else { //return View(); return(Json(new { status = "Client", message = "You are not autherized to buy an enquiry !" })); } } }
private string FillTrainDetail(string trainName, int fileID, string AID, int NoofMachine) { string NewTrainID = null; int t; try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); context.AddParameter("@AID", AID); context.AddParameter("@TrainName", trainName); context.AddParameter("@NoofMachine", NoofMachine); t = context.ExecuteNonQuery("AddTrainInRoute", CommandType.StoredProcedure); } if (t > 0) { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); DataTable dtTrain = context.getData("GetTrainIDForCurrentRoute", CommandType.StoredProcedure); if (dtTrain.Rows.Count > 0) { NewTrainID = Convert.ToString(dtTrain.Rows[0]["NodeID"]); } } } } catch (Exception e) { throw new NotImplementedException(); } return(NewTrainID); }
private string FillMachineDetail(string machineName, int fileID, string TID) { string NewMachineID = null; int m; try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); context.AddParameter("@TID", TID); context.AddParameter("@MachineName", machineName); m = context.ExecuteNonQuery("AddMachineInRoute", CommandType.StoredProcedure); } if (m > 0) { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); DataTable dtMachine = context.getData("GetMachineIDForCurrentRoute", CommandType.StoredProcedure); if (dtMachine.Rows.Count > 0) { NewMachineID = Convert.ToString(dtMachine.Rows[0]["NodeID"]); } } } } catch (Exception e) { throw e; } return(NewMachineID); }
private string FillAreaDetail(string areaName, int fileID, string PID) { string NewAreaID = null; int a; try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); context.AddParameter("@PID", PID); context.AddParameter("@AreaName", areaName); a = context.ExecuteNonQuery("AddAreaInRoute", CommandType.StoredProcedure); } if (a > 0) { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); DataTable dtArea = context.getData("GetAreaIDForCurrentRoute", CommandType.StoredProcedure); if (dtArea.Rows.Count > 0) { NewAreaID = Convert.ToString(dtArea.Rows[0]["NodeID"]); } } } } catch (Exception e) { throw new NotImplementedException(); } return(NewAreaID); }
private string FillPlantDetail(string plantName, int fileID) { string NewPlantID = null; int i; try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); context.AddParameter("@PlantName", plantName); i = context.ExecuteNonQuery("AddPlantInRoute", CommandType.StoredProcedure); } if (i > 0) { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", fileID); DataTable dtPlant = context.getData("GetPlantIDForCurrentRoute", CommandType.StoredProcedure); if (dtPlant.Rows.Count > 0) { NewPlantID = Convert.ToString(dtPlant.Rows[0]["NodeID"]); } } } } catch (Exception e) { throw e; } return(NewPlantID); }
public static double[] getFaultFrequencyData(string Pointid, string Userid) { double[] lstFF = new double[1]; try { using (DBClass context = new DBClass()) { context.AddParameter("@PointID", Pointid); context.AddParameter("@UserName", Userid); DataTable dtFF = context.getData("getFalutFrequencyListbyPointID", CommandType.StoredProcedure); Array.Resize(ref lstFF, dtFF.Rows.Count); if (dtFF.Rows.Count > 0) { int i = 0; foreach (DataRow dr in dtFF.Rows) { lstFF[i] = Convert.ToDouble(dr["FrequencyValue"]); i++; } } } } catch (Exception ex) { throw ex; } return(lstFF); }
public List <ReturnData> GetFileToRead(int FileID, string Userid) { bool status = false; RemoteAnalysisKohtect _kohtect = new RemoteAnalysisKohtect(); List <ReturnData> rList = new List <ReturnData>(); string filePath = null; string newpath = null; string filetype = null; try { if (Userid != null) { using (DBClass _dbConnection = new DBClass()) { _dbConnection.AddParameter("@FileID", FileID); _dbConnection.AddParameter("UserID", Userid); DataTable dtPath = _dbConnection.getData("GetFilePathbyFileID", CommandType.StoredProcedure); filePath = Convert.ToString(dtPath.Rows[0]["FilePath"]); filetype = Convert.ToString(dtPath.Rows[0]["FileType"]); if (filetype != "File") { newpath = ExtractRARFile(filePath, Userid, FileID); status = _kohtect.FileDataSave(FileID, Userid, newpath, filetype); } else { } { status = _kohtect.FileDataSave(FileID, Userid, filePath, filetype); } rList.Add(new ReturnData { Status = status, FileID = FileID, UserID = Userid, MeasurementTime = _kohtect.MeasureTime, UploadTime = DateTime.Now }); } } else { status = false; ModelState.AddModelError("UserIDNotFound", "Please Logout and Login again to complete your process !"); } } catch { } return(rList); }
public ActionResult updateLikes(string blogID) { using (DBClass context = new DBClass()) { DataTable dt = context.getData("Select * from BlogsData where id='" + blogID + "'", CommandType.Text); int likes = Convert.ToInt32(dt.Rows[0]["Likes"]) + 1; context.AddParameter("@Likes", likes); context.AddParameter("@blogID", blogID); context.ExecuteNonQuery("updateBlog", CommandType.StoredProcedure); } return(RedirectToAction("ShowBlogs")); }
public ActionResult Login(LoginViewModel model, string ReturnUrl) { try { if (ModelState.IsValid) { using (DBClass context = new DBClass()) { context.AddParameter("@Username", model.UserName); context.AddParameter("@Password", model.Password); DataTable dtLogin = context.getData("CheckUser", CommandType.StoredProcedure); if (dtLogin.Rows.Count > 0) { WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe); Session["UserRole"] = Convert.ToString(dtLogin.Rows[0]["UserRole"]); Session["UserName"] = Convert.ToString(dtLogin.Rows[0]["LoginId"]); if (Convert.ToString(dtLogin.Rows[0]["UserRole"]) == "Employee") { Session["Department"] = Convert.ToString(dtLogin.Rows[0]["Department"]); } else { Session["Department"] = null; } Session["ConsultantEmailID"] = Convert.ToString(dtLogin.Rows[0]["EmailId"]); Session["IsActiveSession"] = true; Session["ImagePath"] = dtLogin.Rows[0]["Image"].ToString(); Session["FullName"] = Convert.ToString(dtLogin.Rows[0]["Emp_Name"]); Session["UserEmailID"] = Convert.ToString(dtLogin.Rows[0]["EmailId"]); return(RedirectToLocal(ReturnUrl)); //return RedirectToLocal(ViewData["baseUrl"].ToString()); } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } catch (Exception ex) { throw ex; } return(View(model)); }
public JsonResult CreateHierarchy() { List <TreeViewModel> TreeList = new List <TreeViewModel>(); try { using (DBClass context = new DBClass()) { context.AddParameter("@FileID", Convert.ToInt32(Session["FileID"])); DataTable dtHierarchy = context.getData("GetHierarchyData", CommandType.StoredProcedure); ViewBag.FirstNodeID = Convert.ToString(dtHierarchy.Rows[0]["NodeID"]); if (dtHierarchy.Rows.Count > 0) { foreach (DataRow dr in dtHierarchy.Rows) { TreeList.Add(new TreeViewModel { id = Convert.ToString(dr["NodeID"]), text = Convert.ToString(dr["NodeText"]), parent = Convert.ToString(dr["ParentID"]) }); } } } } catch (Exception e) { throw e; } return(Json(TreeList, "True", JsonRequestBehavior.AllowGet)); }
public ActionResult showEnquiryDetail(string EnquiryID) { Enquiry enquiry = new Enquiry(); using (DBClass context = new DBClass()) { context.AddParameter("@EnquiryID", EnquiryID); DataTable dt = context.getData("getEnquiryDetailByID", CommandType.StoredProcedure); if (dt.Rows.Count > 0) { enquiry.UserName = Convert.ToString(dt.Rows[0]["uName"]); enquiry.company = Convert.ToString(dt.Rows[0]["uCompanyName"]); enquiry.phone = Convert.ToString(dt.Rows[0]["uMobile_No"]); enquiry.emailid = Convert.ToString(dt.Rows[0]["Email_ID"]); enquiry.EnquiryID = Convert.ToString(dt.Rows[0]["ID"]); enquiry.Country = Convert.ToString(dt.Rows[0]["Country"]); enquiry.City = Convert.ToString(dt.Rows[0]["City"]); enquiry.State = Convert.ToString(dt.Rows[0]["State"]); enquiry.Enq_Category = Convert.ToString(dt.Rows[0]["EnquiryCategory"]); enquiry.Enq_Subject = Convert.ToString(dt.Rows[0]["EnquirySubject"]); enquiry.EnquiryDetail1 = Convert.ToString(dt.Rows[0]["EnquiryDetail"]); } else { ModelState.AddModelError("", "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator."); } } return(PartialView("_showEnquiryDetail", enquiry)); }
public static List <FileDetail> getPreviousFileData(string UserRole) { List <FileDetail> fileList = new List <FileDetail>(); // creating list of model. string username = HttpContext.Current.Session["UserName"].ToString(); using (DBClass context = new DBClass()) { context.AddParameter("@UserID", username); DataTable dt = context.getData("getPreviousDataByUserID", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { string[] fName = Convert.ToString(dr["FileName"]).Split(new char[] { '@' }, StringSplitOptions.RemoveEmptyEntries); fileList.Add(new FileDetail { FileID = Convert.ToInt16(dr["FileID"]), UserName = Convert.ToString(dr["UserID"]), UploadDate = Convert.ToString(dr["DateOfUpload"]), FileType = Convert.ToString(dr["FileType"]), FileName = Convert.ToString(fName[1]), InstrumentUsed = Convert.ToString(dr["InstrumentUsed"]) }); } return(fileList); } }
public ActionResult ShowDriveUnit(string MachineID) { UploadFile upload = new UploadFile(); upload.DrivenUnitID = Convert.ToInt32(MachineID); TempData["MachineID"] = MachineID.ToString(); ViewBag.DriveID = Convert.ToInt32(MachineID); using (DBClass context = new DBClass()) { DataTable dt = new DataTable(); context.AddParameter("@MachineID", MachineID); dt = context.getData("getDriveUnitByID", CommandType.StoredProcedure); upload.TrainName = Convert.ToString(dt.Rows[0]["MachineName"]); upload.MachineOrientaion = Convert.ToString(dt.Rows[0]["MachineOrientation"]); upload.MountingType = Convert.ToString(dt.Rows[0]["MountingType"]); upload.DEUnitType = Convert.ToString(dt.Rows[0]["DUName"]); upload.DURPM = Convert.ToString(dt.Rows[0]["RPM"]); upload.BearingLubrication = Convert.ToString(dt.Rows[0]["Ber_Lubrication"]); upload.bearingMake = Convert.ToString(dt.Rows[0]["Ber_Manufacture"]); upload.bearingNoDE = Convert.ToString(dt.Rows[0]["Ber_NumberDE"]); upload.bearingNoNDE = Convert.ToString(dt.Rows[0]["Ber_NumberNDE"]); upload.NoOfPoles = Convert.ToInt32(dt.Rows[0]["PolesCount"]); upload.Point_Count_DE = Convert.ToInt32(dt.Rows[0]["Point_Count"]); } return(View("_DriveDetail", upload)); }
public static double[] GetRPMValues(string Pointid, string Userid) { double[] lstFF = new double[1]; double[] lstFF1 = new double[1]; try { using (DBClass context = new DBClass()) { context.AddParameter("@PointID", Pointid); //context.AddParameter("@UserName", Userid); DataTable dtFF = context.getData("getMachineRPMByPointID", CommandType.StoredProcedure); Array.Resize(ref lstFF, dtFF.Rows.Count); if (dtFF.Rows.Count > 0) { int i = 0; foreach (DataRow dr in dtFF.Rows) { lstFF[i] = (Convert.ToDouble(dr["rpmdriven"]) / 60); i++; } } } } catch (Exception) { throw; } return(lstFF); }
public ActionResult getEnquiryStatus(string Id) { using (DBClass context = new DBClass()) { context.AddParameter("@EnquiryID", Id); context.AddParameter("@UserName", Session["UserName"].ToString()); DataTable dt = context.getData("getEnquiryStatus", CommandType.StoredProcedure); if (dt.Rows.Count > 0) { return(Json(new { sts = "True", message = "True" })); } else { return(Json(new { sts = "False", message = "False" })); } } }
public static ArrayList GetData(string nodeid, string userid, ArrayList BearingFrequency) { ArrayList xyData = new ArrayList(); try { double[] Xdoubles = new double[1]; double[] Ydoubles = new double[1]; //string[] ffData = getFaultFrequencyData(nodeid, userid);//used for frequency name with value.. ////////////// Chages for bearing fault frequency ///////////////////// double[] bearingFrequency = new double[BearingFrequency.Count]; for (int i = 0; i < BearingFrequency.Count; i++) { string[] bff = (Convert.ToString(BearingFrequency[i])).Split(new char[] { '=' }); bearingFrequency[i] = Convert.ToDouble(bff[1]); } double[] faultFrequency = getFaultFrequencyData(nodeid, userid); using (DBClass context = new DBClass()) { context.AddParameter("@Nodeid", nodeid); DataTable dtData = context.getData("GetRecordedDataByPointID", CommandType.StoredProcedure); foreach (DataRow dr in dtData.Rows) { string[] xData = Convert.ToString(dr["Chnl1FFT_X"]).Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); string[] yData = Convert.ToString(dr["Chnl1FFT_Y"]).Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); Array.Resize(ref Xdoubles, xData.Length); Array.Resize(ref Ydoubles, xData.Length); Xdoubles = Array.ConvertAll(xData, new Converter <string, double>(Double.Parse)); Ydoubles = Array.ConvertAll(yData, new Converter <string, double>(Double.Parse)); ChartData.xAxisUnit = "Frequency-Hz"; ChartData.yAxisUnit = Convert.ToString(dr["OverallUnitChnlA"]); if (ChartData.yAxisUnit == "mm/sec" || ChartData.yAxisUnit == "inch/sec") { ChartData.amplitudeUnit = "Velocity ( " + ChartData.yAxisUnit + " )"; } if (ChartData.yAxisUnit == "G" || ChartData.yAxisUnit == "m/s2") { ChartData.amplitudeUnit = "Acceleration ( " + ChartData.yAxisUnit + " )"; } if (ChartData.yAxisUnit == "um" || ChartData.yAxisUnit == "mil") { ChartData.amplitudeUnit = "Displacement ( " + ChartData.yAxisUnit + " )"; } ChartData.overallValue = Convert.ToDouble(dr["OverallValueChnlA"]); } } xyData.Add(Xdoubles); xyData.Add(Ydoubles); xyData.Add(FindNearestPointIndex(faultFrequency, Xdoubles)); xyData.Add(FindNearestPointIndex(bearingFrequency, Xdoubles)); } catch (Exception ex) { throw ex; } return(xyData); }
//[InitializeSimpleMembership] public ActionResult buyEnquiry(string Id) { try { using (DBClass context = new DBClass()) { var uname = Session["UserName"].ToString(); SessionClass.Username = uname; context.AddParameter("@Username", Session["UserName"].ToString()); DataSet ds = context.ExecuteDataSet("getUserRole", CommandType.StoredProcedure); if (Convert.ToString(ds.Tables[0].Rows[0]["UserRole"]) != "Client") { DataTable dt = new DataTable(); context.AddParameter("@UserName", Session["UserName"].ToString()); context.AddParameter("@EnquiryID", Convert.ToInt32(Id)); dt = context.getData("getExpertBalance", CommandType.StoredProcedure); //int CurrentBalance = Convert.ToInt32(dt.Rows[0]["Current_PointBalance"]); int enquiryCost = Convert.ToInt32(dt.Rows[0]["Enquiry_Cost"]); DataSet dsEmp = context.ExecuteDataSet("Select * from [Emp_Detail] where [LoginID]='" + uname + "'", CommandType.Text); int UserID = (int)dsEmp.Tables[0].Rows[0]["AutoId"]; context.ExecuteNonQuery("INSERT INTO [dbo].[Enquiry_Buyer] ([EnquiryID] ,[BuyerID] ,[Buyer_Name] ,[Enquiry_Cost] ,[DateofBuying]) VALUES(" + Convert.ToInt32(Id) + ",'" + UserID + "','" + uname + "'," + enquiryCost + ",'" + DateTime.Now.ToLocalTime().ToString() + "')", CommandType.Text); SendPurchaseMail(uname, Convert.ToInt32(Id), Convert.ToInt32(UserID), enquiryCost); //Payment(enquiryCost.ToString()); //return Json(new { status = "Success", message = "hello !" }); return(RedirectToAction("Payment", new { Amount = enquiryCost, EnquiryId = Id.ToString() })); } else { //return View(); return(Json(new { status = "Client", message = "You are not autherized to buy an enquiry !" })); } } } catch (Exception ex) { return(RedirectToAction("Errormessage")); } }
public ActionResult MachineDetail(FormCollection form, UploadFile up) { int id = Convert.ToInt32(up.FileID); using (DBClass context = new DBClass()) { int totalPoint = 0; context.AddParameter("@FileID", id); DataTable DEPoint = context.getData("getDEPointCountbyFileID", CommandType.StoredProcedure); foreach (DataRow dr in DEPoint.Rows) { totalPoint += Convert.ToInt32(dr["Point_Count"]); } context.AddParameter("@FileID", id); DataTable NDEPoint = context.getData("getNDEPointCountbyFileID", CommandType.StoredProcedure); foreach (DataRow dr in NDEPoint.Rows) { totalPoint += Convert.ToInt32(dr["Point_Count"]); } if (context.ExecuteNonQuery("Update UploadData set PointCount = '" + totalPoint + "' where ID = '" + id + "' ", CommandType.Text) > 0) { DataTable dt1 = context.getData("Select AnalysisType from UploadData where ID = '" + id + "'", CommandType.Text); double cost = 0; if (Convert.ToString(dt1.Rows[0]["AnalysisType"]) == "Indicative Analysis") { cost = 140 * totalPoint; } else { cost = 680 * totalPoint; } context.ExecuteNonQuery("Update PaymentDetail set Amount = '" + cost + "' where FileID = '" + id + "' ", CommandType.Text); ModelState.Clear(); return(RedirectToAction("ClientList", "Clients")); } } return(View()); }
public List <ReturnData> GetFileToAnalyse(int FileID, string Userid) { bool status = false; RemoteAnalysisKohtect _kohtect = new RemoteAnalysisKohtect(); List <ReturnData> rList = new List <ReturnData>(); try { if (Userid != null) { using (DBClass _dbConnection = new DBClass()) { _dbConnection.AddParameter("@FileID", FileID); _dbConnection.AddParameter("UserID", Userid); DataTable dtPath = _dbConnection.getData("GetFileData", CommandType.StoredProcedure); rList.Add(new ReturnData { Status = true, FileID = FileID, UserID = Userid, MeasurementTime = Convert.ToDateTime(dtPath.Rows[0]["MeasureTime"]), UploadTime = Convert.ToDateTime(dtPath.Rows[0]["DateOfUpload"]), }); } } else { status = false; ModelState.AddModelError("UserIDNotFound", "Please Logout and Login again to complete your process !"); } } catch { } return(rList); }
/// <summary> /// To fill all the data for hierarchy in the database on the basis of uploaded file. /// It uses stored procedure AddPlant,AddArea,AddTrain,AddMachine and AddPoint respectivly with all required parameters. /// </summary> public string FillRouteDetail(string filename) { string PID = null; try { string[] fname = filename.Split(new string[] { "@" }, StringSplitOptions.RemoveEmptyEntries); using (DBClass _dbConnection = new DBClass()) { _dbConnection.AddParameter("@FileID", FileID); _dbConnection.AddParameter("@NoofMachine", 1); _dbConnection.AddParameter("@FileName", fname[fname.Length - 1]); _dbConnection.ExecuteNonQuery("AddRouteData", CommandType.StoredProcedure); } using (DBClass context = new DBClass()) { context.AddParameter("@FileID", FileID); DataTable dt = context.getData("GetPointIDForCurrentRoute", CommandType.StoredProcedure); PID = Convert.ToString(dt.Rows[0]["NodeID"]); } } catch { } return(PID); }
public static ArrayList GetUnitXY(string nodeid, string userid, ArrayList XYUnit) { ArrayList XYdata = new ArrayList(); try { double[] Xdoubles = new double[1]; double[] Ydoubles = new double[1]; using (DBClass context = new DBClass()) { context.AddParameter("@NodeId", nodeid); DataTable dtData = context.getData("GetRecordDataByPointID", CommandType.StoredProcedure); foreach (DataRow dr in dtData.Rows) { string[] xData = Convert.ToString(dr["Chnl1FFT_X"]).Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); string[] yData = Convert.ToString(dr["Chnl1FFT_Y"]).Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); Array.Resize(ref Xdoubles, xData.Length); Array.Resize(ref Ydoubles, yData.Length); Xdoubles = Array.ConvertAll(xData, new Converter <string, double>(double.Parse)); Ydoubles = Array.ConvertAll(yData, new Converter <string, double>(double.Parse)); ChartData.xAxisUnit = "Ferquecy-HZ"; ChartData.yAxisUnit = Convert.ToString(dr["OverallChnlA"]); if (ChartData.yAxisUnit == "mm/sec" || ChartData.yAxisUnit == "inch/sec") { ChartData.amplitudeUnit = "Velocity ( " + ChartData.xAxisUnit + " )"; } ChartData.overallValue = Convert.ToDouble(dr["OverallValueChnlA"]); } } XYdata.Add(Xdoubles); XYdata.Add(Ydoubles); // XYdata.Add(FindNearestPointIndex1(RPM, Xdoubles)); } catch (Exception) { throw; } return(XYdata); }
private bool CheckDuplicateFileRecord(int fileid, string userid) { bool sts = false; try { using (DBClass context = new DBClass()) { context.AddParameter("@Fileid", fileid); DataTable dt = context.getData("GetRecordedDataByFileID", CommandType.StoredProcedure); if (dt.Rows.Count > 0) { sts = true; } } } catch (Exception ex) { throw ex; } return(sts); }
public ActionResult EditDriveUnit(UploadFile edit, string MachineID) { using (DBClass context = new DBClass()) { context.AddParameter("@MachineID", MachineID); DataTable dt = context.getData("Select * from MachineInfo mi inner join DriveMachineDetail de on mi.ID= de.MachineID where mi.ID='" + MachineID + "'", CommandType.Text); edit.TrainName = Convert.ToString(dt.Rows[0]["MachineName"]); edit.MachineOrientaion = Convert.ToString(dt.Rows[0]["MachineOrientation"]); edit.MountingType = Convert.ToString(dt.Rows[0]["MountingType"]); edit.DEUnitType = Convert.ToString(dt.Rows[0]["DUName"]); edit.DURPM = Convert.ToString(dt.Rows[0]["RPM"]); edit.BearingLubrication = Convert.ToString(dt.Rows[0]["Ber_Lubrication"]); edit.bearingMake = Convert.ToString(dt.Rows[0]["Ber_Manufacture"]); edit.bearingNoDE = Convert.ToString(dt.Rows[0]["Ber_NumberDE"]); edit.bearingNoNDE = Convert.ToString(dt.Rows[0]["Ber_NumberNDE"]); edit.NoOfPoles = Convert.ToInt32(dt.Rows[0]["PolesCount"]); edit.Point_Count_DE = Convert.ToInt32(dt.Rows[0]["Point_Count"]); return(View("_EditDriveUnit", edit)); } }
public JsonResult getCity(int stateid) { try { using (DBClass context = new DBClass()) { dtList.Clear(); context.AddParameter("@StateID", stateid); dtList = context.getData("getCityByState", CommandType.Text); for (int i = 0; i < dtList.Rows.Count; i++) { City.Add(new SelectListItem { Text = Convert.ToString(dtList.Rows[i]["CityName"]), Value = Convert.ToString(dtList.Rows[i]["CityID"]) }); } } } catch { } return(Json(City, JsonRequestBehavior.AllowGet)); }
public ActionResult MachineDetail(UploadFile uploadMachine) { //bool filetype = false; using (DBClass context = new DBClass()) { context.AddParameter("@UserName", Session["UserName"].ToString()); DataTable dt = context.getData("getCurrentFileDetail", CommandType.StoredProcedure); //if (Convert.ToString(dt.Rows[0]["FileType"]) == "Data") //{ // filetype = true; //} uploadMachine.FileID = Convert.ToInt32(dt.Rows[0]["ID"]); uploadMachine.fileName1 = Convert.ToString(dt.Rows[0]["FileName"]); uploadMachine.Instrument = Convert.ToString(dt.Rows[0]["InstrumentUsed"]); uploadMachine.AnalysisType = Convert.ToString(dt.Rows[0]["AnalysisType"]); uploadMachine.Description = Convert.ToString(dt.Rows[0]["Description"]); } ViewBag.FileID = uploadMachine.FileID; return(View(uploadMachine)); }
public ActionResult ShowDrivenUnit(string MachineID) { UploadFile upload = new UploadFile(); using (DBClass context = new DBClass()) { DataTable dt = new DataTable(); context.AddParameter("@MachineID", MachineID); dt = context.getData("getDrivenUnitByID", CommandType.StoredProcedure); upload.NDEUnit1 = Convert.ToString(dt.Rows[0]["Machine_Name"]); upload.NDEType = Convert.ToString(dt.Rows[0]["Machine_Type"]); upload.TransmissionType = Convert.ToString(dt.Rows[0]["Transmission_Type"]); upload.BearingLubrication = Convert.ToString(dt.Rows[0]["Ber_Lubrication"]); upload.bearingMake = Convert.ToString(dt.Rows[0]["Ber_Manufacture"]); upload.bearingNoDE = Convert.ToString(dt.Rows[0]["Ber_DE"]); upload.bearingNoNDE = Convert.ToString(dt.Rows[0]["Ber_NDE"]); upload.bearingDEIn = Convert.ToString(dt.Rows[0]["Ber_DE_IN"]); upload.bearingDEOut = Convert.ToString(dt.Rows[0]["Ber_DE_OUT"]); upload.bearingNDEIn = Convert.ToString(dt.Rows[0]["Ber_NDE_IN"]); upload.bearingNDEOut = Convert.ToString(dt.Rows[0]["Ber_NDE_OUT"]); upload.bearingDEIdler = Convert.ToString(dt.Rows[0]["Ber_DE_Idle"]); upload.bearingNDEIdler = Convert.ToString(dt.Rows[0]["Ber_NDE_Idle"]); upload.InputRPM = Convert.ToDouble(dt.Rows[0]["Input_RPM"]); upload.OutputRPM = Convert.ToDouble(dt.Rows[0]["Output_RPM"]); upload.GearRatio = Convert.ToString(dt.Rows[0]["Gear_Ratio"]); upload.TeethCountInput = Convert.ToInt32(dt.Rows[0]["Teeth_Input_Count"]); upload.TeethCountOutput = Convert.ToInt32(dt.Rows[0]["Teeth_Output_Count"]); upload.TeethCountIdle = Convert.ToInt32(dt.Rows[0]["Teeth_Idler_Count"]); upload.NDERPM = Convert.ToDouble(dt.Rows[0]["RPM"]); upload.BladesorFins = Convert.ToInt32(dt.Rows[0]["BladesORFins"]); upload.BeltType = Convert.ToString(dt.Rows[0]["Belt_Type"]); upload.BeltCount = Convert.ToInt32(dt.Rows[0]["Belt_Count"]); upload.BeltLength = Convert.ToDouble(dt.Rows[0]["Belt_Length"]); upload.PitchDia = Convert.ToDouble(dt.Rows[0]["Pitch_Dia"]); upload.TeethCount = Convert.ToInt32(dt.Rows[0]["Teeth_Count"]); upload.Point_Count_NDE = Convert.ToInt32(dt.Rows[0]["Point_Count"]); } return(View("_DrivenDetail", upload)); }