private int UpdateName(ClassDBModel dbModel) { SqlConnection conn = new SqlConnection(DBConnection.GetConnection()); conn.Open(); SqlCommand dCmd = new SqlCommand("UPDATE Class SET ClassName=@ClassName,AddedBy=@AddedBy WHERE ClassID=@ClassID ", conn); dCmd.CommandType = CommandType.Text; try { dCmd.Parameters.AddWithValue("@ClassName", dbModel.ClassName); dCmd.Parameters.AddWithValue("@ClassID", dbModel.ClassID); dCmd.Parameters.AddWithValue("@AddedBy", "Forhad"); return(dCmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dCmd.Dispose(); conn.Close(); conn.Dispose(); } }
public JsonResult LoadSelectedClass(ClassDBModel _dbModel) { List <ClassDBModel> _dbModelList = new List <ClassDBModel>(); _dbModelList = LoadSelectedClassName(_dbModel); return(this.Json(_dbModelList, JsonRequestBehavior.AllowGet)); }
private int SaveName(ClassDBModel _dbModel) { SqlConnection conn = new SqlConnection(DBConnection.GetConnection()); conn.Open(); SqlCommand dCmd = new SqlCommand(@"INSERT INTO Class (ClassName, AddedBy) VALUES(@ClassName, @AddedBy)", conn); dCmd.CommandType = System.Data.CommandType.Text; try { dCmd.Parameters.AddWithValue("@ClassID", 0); dCmd.Parameters.AddWithValue("@ClassName", _dbModel.ClassName); dCmd.Parameters.AddWithValue("@AddedBy", "Iqbal"); return(dCmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dCmd.Dispose(); conn.Close(); conn.Dispose(); } }
public JsonResult DeleteSelectedClass(ClassDBModel _dbModel) { int _result = 0; _result = DeleteClassName(_dbModel); if (_result > 0) { return(Json(new { success = true })); } else { return(Json(new { success = false })); } }
public JsonResult SaveData(ClassDBModel _dbModel) { int Result = 0; Result = SaveName(_dbModel); if (Result > 0) { return(Json(new { Success = true })); } else { return(Json(new { Success = true })); } }
public JsonResult SaveData(ClassDBModel _dbModel) { int Result = 0; if (_dbModel.ClassID > 0) { Result = UpdateName(_dbModel); } else { Result = SaveName(_dbModel); } if (Result > 0) { return(Json(new { Success = true })); } else { return(Json(new { Success = false })); } }
//public ActionResult Info(int ClassID, string reportTypes) //{ // try // { // //string reportTypes = "EXCELOPENXML"; // DataSet ds = new DataSet(); // LocalReport localReport = new LocalReport(); // ds = LoadAllCG01Report(ClassID); // localReport.ReportPath = Server.MapPath("~/Reports/Report1.rdlc"); // ReportDataSource reportDataSource1 = new ReportDataSource(); // reportDataSource1.Name = "DataSet1"; // reportDataSource1.Value = ds.Tables[0]; // //ReportDataSource reportDataSource2 = new ReportDataSource(); // //reportDataSource2.Name = "Info1"; // //reportDataSource2.Value = ds.Tables[0]; // ReportParameter ClassName = new ReportParameter("ClassName", ds.Tables[0].Rows[0]["ClassName"].ToString()); // //ReportParameter PCostingRef = new ReportParameter("CostingRef", ds.Tables[0].Rows[0]["CostingRef"].ToString()); // //ReportParameter PCompanyName = new ReportParameter("CompanyName", ds.Tables[0].Rows[0]["CompanyName"].ToString()); // //ReportParameter PBuyerName = new ReportParameter("BuyerName", ds.Tables[0].Rows[0]["BuyerName"].ToString()); // //ReportParameter PStyleID = new ReportParameter("StyleID", " "); // localReport.SetParameters(parameters: new ReportParameter[] { ClassName }); // //PCostingRef, PCompanyName, PBuyerName, // ////PStyleID,PStyleName, PProductTypeName, PSAM, PCM,PFOB, POrderQty, PTargetPerDay, PEfficiency,PRemarks,Commission, // ////NegoFabCost,NegoTrimCost,NegoWashCost,NegoArtCost,NegoTestCost,NegoOtherCost,TotalFabCost,TotalTrimCost, // ////TotalWashCost,TotalEmbCost,TotalOtherCost}); // localReport.Refresh(); // localReport.DataSources.Add(reportDataSource1); // //localReport.DataSources.Add(reportDataSource2); // string reportType = reportTypes; // string mimeType; // string encoding; // string fileNameExtension = ""; // //The DeviceInfo settings should be changed based on the reportType // //http://msdn2.microsoft.com/en-us/library/ms155397.aspx // string deviceInfo = "<DeviceInfo>" + // " <OutputFormat>PDF</OutputFormat>" + // " <PageWidth>8.50in</PageWidth>" + // " <PageHeight>11.69in</PageHeight>" + // " <MarginTop>.2in</MarginTop>" + // " <MarginLeft>.5in</MarginLeft>" + // " <MarginRight>.5in</MarginRight>" + // " <MarginBottom>.2in</MarginBottom>" + // "</DeviceInfo>"; // Warning[] warnings; // string[] streams; // byte[] renderedBytes; // renderedBytes = localReport.Render(reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); // if (reportType == "EXCELOPENXML") // { // return File(renderedBytes, mimeType, "Info.xlsx"); // } // else // { // return File(renderedBytes, mimeType, "Info.pdf"); // } // } // catch (Exception ex) // { // throw ex; // } //} //public DataSet LoadAllCG01Report(int ClassID) //{ // List<ClassDBModel> _modelList = new List<ClassDBModel>(); // SqlConnection conn = new SqlConnection(DBConnection.GetConnection()); // conn.Open(); // SqlCommand dAd = new SqlCommand("SELECT * FROM Class WHERE ClassID=@ClassID", conn); // SqlDataAdapter sda = new SqlDataAdapter(dAd); // dAd.CommandType = CommandType.Text; // dAd.Parameters.AddWithValue("@ClassID", ClassID); // DataSet ds = new DataSet(); // try // { // sda.Fill(ds); // return ds; // } // catch (Exception ex) // { // //UtilityOptions.ErrorLog(ex.ToString(), MethodBase.GetCurrentMethod().Name); // throw ex; // } // finally // { // ds.Dispose(); // dAd.Dispose(); // conn.Close(); // conn.Dispose(); // } //} private List <ClassDBModel> LoadSelectedClassName(ClassDBModel dbModel) { List <ClassDBModel> _modelList = new List <ClassDBModel>(); SqlConnection conn = new SqlConnection(DBConnection.GetConnection()); conn.Open(); SqlCommand dAd = new SqlCommand("SELECT * FROM Class WHERE ClassID=@ClassID", conn); SqlDataAdapter sda = new SqlDataAdapter(dAd); dAd.CommandType = CommandType.Text; dAd.Parameters.AddWithValue("@ClassID", dbModel.ClassID); DataTable dt = new DataTable(); try { sda.Fill(dt); if (dt.Rows.Count > 0) { _modelList = (from DataRow row in dt.Rows select new ClassDBModel { ClassID = Convert.ToInt32(row["ClassID"].ToString()), ClassName = row["ClassName"].ToString(), AddedBy = row["AddedBy"].ToString() }).ToList(); } return(_modelList); } catch (Exception ex) { throw ex; } finally { dt.Dispose(); dAd.Dispose(); conn.Close(); conn.Dispose(); } }
private int DeleteClassName(ClassDBModel dbModel) { SqlConnection conn = new SqlConnection(DBConnection.GetConnection()); conn.Open(); SqlCommand dCmd = new SqlCommand("DELETE FROM Class WHERE ClassID = @ClassID", conn); dCmd.CommandType = CommandType.Text; try { dCmd.Parameters.AddWithValue("@ClassID", dbModel.ClassID); return(dCmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dCmd.Dispose(); conn.Close(); conn.Dispose(); } }