public Category SaveCategory(Category ObjCategory) { int CategoryID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_CATEGORY]"; cmd.Parameters.AddWithValue("@CATEGORYID", ObjCategory.CATEGORYID); cmd.Parameters.AddWithValue("@CATEGORYNAME", ObjCategory.CATEGORYNAME); cmd.Parameters.AddWithValue("@ALLOWOPENITEMS", ObjCategory.AllowOpenItems); cmd.Parameters.AddWithValue("@USERID", ObjCategory.UserID); object objReturn = cmd.ExecuteScalar(); string str = Convert.ToString(objReturn); if (!int.TryParse(str, out CategoryID)) { throw new Exception(str); } else { ObjCategory.CATEGORYID = objReturn; } } } catch (Exception ex) { if (ex.Message.Contains("UC_CATEGORYNAME")) { throw new Exception("Category Already Exists!!"); } else { throw new Exception("Error While Saving Category"); } } finally { SQLCon.Sqlconn().Close(); } return(ObjCategory); }
public PrinterSettings SavePrinterSettings(PrinterSettings ObjPrinterSettings) { int PRINTERSETTINGSID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_PRINTERSETTINGS]"; cmd.Parameters.AddWithValue("@PRINTERSETTINGSID", ObjPrinterSettings.PRINTERSETTINGSID); cmd.Parameters.AddWithValue("@PRINTERTYPEID", ObjPrinterSettings.PRINTERTYPEID); cmd.Parameters.AddWithValue("@PRINTERNAME", ObjPrinterSettings.PRINTERNAME); cmd.Parameters.AddWithValue("@USERID", ObjPrinterSettings.UserID); object objReturn = cmd.ExecuteScalar(); string str = Convert.ToString(objReturn); if (!int.TryParse(str, out PRINTERSETTINGSID)) { throw new Exception(str); } else { ObjPrinterSettings.PRINTERSETTINGSID = objReturn; } } } catch (Exception ex) { if (ex.Message.Contains("UC_PRINTERSETTING")) { throw new Exception("Printer Already Exists!!"); } else { throw new Exception("Error While Saving Printer"); } } finally { SQLCon.Sqlconn().Close(); } return(ObjPrinterSettings); }
public MOP SaveMOP(MOP ObjMOP) { int MOPID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_MOP]"; cmd.Parameters.AddWithValue("@MOPID", ObjMOP.MOPID); cmd.Parameters.AddWithValue("@MOPNAME", ObjMOP.MOPNAME); cmd.Parameters.AddWithValue("@USERID", ObjMOP.UserID); object objReturn = cmd.ExecuteScalar(); string str = Convert.ToString(objReturn); if (!int.TryParse(str, out MOPID)) { throw new Exception(str); } else { ObjMOP.MOPID = objReturn; } } } catch (Exception ex) { if (ex.Message.Contains("UC_MOPNAME")) { throw new Exception("MOP Already Exists!!"); } else { throw new Exception("Error While Saving MOP"); } } finally { SQLCon.Sqlconn().Close(); } return(ObjMOP); }
/// <summary> /// Code to fetch non active deliveries from database /// </summary> /// <param name="ObjEDeliveryNotes"></param> /// <returns></returns> public EDeliveryNotes GetNonActiveDelivery(EDeliveryNotes ObjEDeliveryNotes) { DataSet dsPositions = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_NonActivedelivery]"; cmd.Parameters.AddWithValue("@ProjectID", ObjEDeliveryNotes.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsPositions); } ObjEDeliveryNotes.dtNonActivedelivery = dsPositions.Tables[0]; if (ObjEDeliveryNotes.dtNonActivedelivery.Rows.Count > 0 && dsPositions.Tables[1].Rows.Count > 0) { ObjEDeliveryNotes.BlattID = dsPositions.Tables[1].Rows[0]["BlattID"] == DBNull.Value ? -1 : Convert.ToInt32(dsPositions.Tables[1].Rows[0]["BlattID"]); ObjEDeliveryNotes.BlattName = dsPositions.Tables[1].Rows[0]["BlattNumber"] == DBNull.Value ? "" : dsPositions.Tables[1].Rows[0]["BlattNumber"].ToString(); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Error While Retrieving the Positions"); } else { throw new Exception("Error While Retrieving the Positions"); } } finally { SQLCon.Close(); } return(ObjEDeliveryNotes); }
/// <summary> /// Code to update long description of position /// </summary> /// <param name="PositionID"></param> /// <param name="strLongDescription"></param> public void UpdateLongDescription(int PositionID, string strLongDescription) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Upd_LongDescription]"; cmd.Parameters.AddWithValue("@PositionID", PositionID); cmd.Parameters.AddWithValue("@LongDescription", strLongDescription); cmd.ExecuteNonQuery(); } } catch (Exception ex) { throw; } }
/// <summary> /// Code to fetch special cost of a project /// </summary> /// <param name="ObjEUmlage"></param> /// <returns></returns> public EUmlage GetSpecialCost(EUmlage ObjEUmlage) { try { ObjEUmlage.dtSpecialCost = new DataTable(); DataSet ds = new DataSet(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_SpecialCost]"; cmd.Parameters.Add("@ProjectID", ObjEUmlage.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } if (ds != null && ds.Tables.Count > 0) { ObjEUmlage.dtSpecialCost = ds.Tables[0]; if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0) { int.TryParse(Convert.ToString(ds.Tables[1].Rows[0][0]), out ObjEUmlage.UmlageMode); } } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Generellen Kosten"); } else { throw new Exception("Error while retrieving special cost"); } } finally { SQLCon.Close(); } return(ObjEUmlage); }
/// <summary> /// Code to fetch article Prices from database by using Article number and Dimenstions /// </summary> /// <param name="ObjEPositon"></param> /// <returns></returns> public EPosition GetArticleByDimension(EPosition ObjEPositon) { DataTable dt = new DataTable(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ArticleByDimension]"; cmd.Parameters.AddWithValue("@WG", ObjEPositon.WG); cmd.Parameters.AddWithValue("@WA", ObjEPositon.WA); cmd.Parameters.AddWithValue("@WI", ObjEPositon.WI); cmd.Parameters.AddWithValue("@A", ObjEPositon.Dim1); cmd.Parameters.AddWithValue("@B", ObjEPositon.Dim2); cmd.Parameters.AddWithValue("@L", ObjEPositon.Dim3); cmd.Parameters.AddWithValue("@dtSubmitDate", ObjEPositon.ValidityDate); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } if (dt != null && dt.Rows.Count > 0) { ObjEPositon.dtDimensions = dt.Copy(); ObjEPositon.LPMA = dt.Rows[0]["ListPrice"] == DBNull.Value ? 1 : Convert.ToDecimal(dt.Rows[0]["ListPrice"]); ObjEPositon.Mins = dt.Rows[0]["Minuten"] == DBNull.Value ? 1 : Convert.ToDecimal(dt.Rows[0]["Minuten"]); ObjEPositon.Faktor = dt.Rows[0]["Factor"] == DBNull.Value ? 1 : Convert.ToDecimal(dt.Rows[0]["Factor"]); DateTime dtdate = DateTime.Now; if (DateTime.TryParse(Convert.ToString(dt.Rows[0]["ValidityDate"]), out dtdate)) { ObjEPositon.ValidityDate = dtdate; } } } } catch (Exception ex) { throw; } return(ObjEPositon); }
/// <summary> /// Code to fetch article details and dimensions list from database by using typ /// </summary> /// <param name="ObjEPositon"></param> /// <returns></returns> public EPosition GetArticleByTyp(EPosition ObjEPositon) { DataSet ds = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ArticleByType]"; cmd.Parameters.AddWithValue("@Typ", ObjEPositon.Type); cmd.Parameters.AddWithValue("@dtSubmitDate", ObjEPositon.ValidityDate); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { ObjEPositon.dtArticle = ds.Tables[0]; ObjEPositon.WG = ds.Tables[0].Rows[0]["WG"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["WG"].ToString(); ObjEPositon.WA = ds.Tables[0].Rows[0]["WA"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["WA"].ToString(); ObjEPositon.WI = ds.Tables[0].Rows[0]["WI"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["WI"].ToString(); ObjEPositon.Fabricate = ds.Tables[0].Rows[0]["Fabrikate"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["Fabrikate"].ToString(); ObjEPositon.ME = ds.Tables[0].Rows[0]["Menegenheit"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["Menegenheit"].ToString(); ObjEPositon.Dim = ds.Tables[0].Rows[0]["Masseinheit"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["Masseinheit"].ToString(); ObjEPositon.Faktor = ds.Tables[0].Rows[0]["Factor"] == DBNull.Value ? 1 : Convert.ToDecimal(ds.Tables[0].Rows[0]["Factor"]); ObjEPositon.LiefrantMA = ds.Tables[0].Rows[0]["FullName"] == DBNull.Value ? "" : ds.Tables[0].Rows[0]["FullName"].ToString(); ObjEPositon.Multi1MA = ds.Tables[0].Rows[0]["Multi1"] == DBNull.Value ? 1 : Convert.ToDecimal(ds.Tables[0].Rows[0]["Multi1"]); ObjEPositon.Multi2MA = ds.Tables[0].Rows[0]["Multi2"] == DBNull.Value ? 1 : Convert.ToDecimal(ds.Tables[0].Rows[0]["Multi2"]); ObjEPositon.Multi3MA = ds.Tables[0].Rows[0]["Multi3"] == DBNull.Value ? 1 : Convert.ToDecimal(ds.Tables[0].Rows[0]["Multi3"]); ObjEPositon.Multi4MA = ds.Tables[0].Rows[0]["Multi4"] == DBNull.Value ? 1 : Convert.ToDecimal(ds.Tables[0].Rows[0]["Multi4"]); if (ds.Tables.Count > 1) { ObjEPositon.dtDimensions = ds.Tables[1]; } } } } catch (Exception ex) { throw; } return(ObjEPositon); }
/// <summary> /// Code to get Organization details /// </summary> /// <param name="ObjEOTTO"></param> /// <returns></returns> public EOTTO GetOTTODetails(EOTTO ObjEOTTO) { DataSet dsOTTO = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_OTTODetails]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsOTTO); } if (dsOTTO != null && dsOTTO.Tables.Count > 0) { ObjEOTTO.dtOTTO = dsOTTO.Tables[0]; if (dsOTTO.Tables.Count > 1) { ObjEOTTO.dtContact = dsOTTO.Tables[1]; } } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der daten zu OTTO"); } else { throw new Exception("Error Occured While Retreiving OTTO details"); } } finally { SQLCon.Close(); } return(ObjEOTTO); }
/// <summary> /// Code to export positions from supplier proposal /// </summary> /// <param name="SupplierProposalID"></param> /// <returns></returns> public DataSet GetSupplierProposalExport(int SupplierProposalID) { DataSet dsTMLData = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[p_Get_SupplierProposalExport]"; cmd.Parameters.AddWithValue("@SupplierProposalID", SupplierProposalID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsTMLData, "TMLData"); } } } catch (Exception ex) { if (ex.Message.Contains("RasterError")) { throw new Exception("Betrieb nicht möglich mit altem Raster"); } else { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Positionsliste"); } else { throw new Exception("Error Occured While Retreiving Position List"); } } } finally { SQLCon.Close(); } return(dsTMLData); }
/// <summary> /// Code to update values to position from Bulk proccess Section A /// </summary> /// <param name="ProjectID"></param> /// <param name="tType"></param> /// <param name="MA_Selbstkosten"></param> /// <param name="MO_Selbstkosten"></param> /// <param name="MA_Verkaufspreis"></param> /// <param name="MO_Verkaufspreis"></param> /// <param name="dt"></param> /// <returns></returns> public DataSet UpdateBulkProcess_ActionA(int ProjectID, string tType, decimal MA_Selbstkosten, decimal MO_Selbstkosten, decimal MA_Verkaufspreis, decimal MO_Verkaufspreis, DataTable dt) { DataSet dsPositionsOZList = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Upd_BulkProcess_ActionA]"; cmd.Parameters.AddWithValue("@ProjectID", ProjectID); cmd.Parameters.AddWithValue("@Position_Type", tType); cmd.Parameters.AddWithValue("@MA_selbstkostenMulti", MA_Selbstkosten); cmd.Parameters.AddWithValue("@MO_selbstkostenMulti", MO_Selbstkosten); cmd.Parameters.AddWithValue("@MA_verkaufspreis_Multi", MA_Verkaufspreis); cmd.Parameters.AddWithValue("@MO_verkaufspreisMulti", MO_Verkaufspreis); cmd.Parameters.AddWithValue("@Bulk_Process_ActionA_Table", dt); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsPositionsOZList, "Positions"); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Positionsliste"); } else { throw new Exception("Error Occured While Retreiving Position OZ List"); } } finally { SQLCon.Close(); } return(dsPositionsOZList); }
/// <summary> /// Code to get Articles based on cost type mapping /// </summary> /// <param name="ObjEFormBlatt"></param> /// <returns></returns> public EFormBlatt Get_FormBlattArticles(EFormBlatt ObjEFormBlatt) { DataSet dsFormBlattArticle = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ArticleForFormBlatt]"; cmd.Parameters.Add("@CostTypeID", ObjEFormBlatt.LookUpID); cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsFormBlattArticle); } if (dsFormBlattArticle != null && dsFormBlattArticle.Tables.Count > 0) { ObjEFormBlatt.dtBlattArticles = dsFormBlattArticle.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Ein Fehler ist aufgetreten beim Laden des Formulars (Artikel)"); } else { throw new Exception("Error Occured While Retreiving FormBlatt Articles"); } } finally { SQLCon.Close(); } return(ObjEFormBlatt); }
public int SavePositionDetails(XmlDocument XmlDoc, byte[] LongDescription) { int ProjectID = -1; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_Position]"; SqlParameter param = new SqlParameter("@XMLPositions", SqlDbType.Xml); param.Value = XmlDoc.InnerXml; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@LongDescription", LongDescription); object returnObj = cmd.ExecuteScalar(); if (returnObj != null) { if (returnObj.ToString().Contains("UNIQUE")) { throw new Exception("OZ Already Exists"); } else if (!int.TryParse(returnObj.ToString(), out ProjectID)) { throw new Exception("Error Occured While Saving the Position Details"); } } } } catch (Exception ex) { throw; } finally { SQLCon.Sqlconn().Close(); } return(ProjectID); }
public int SaveOffer(Offer offer) { int OfferID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_OFFER]"; cmd.Parameters.AddWithValue("@OfferID", offer.OfferID); cmd.Parameters.AddWithValue("@OfferName", offer.OfferName); cmd.Parameters.AddWithValue("@OfferCode", offer.OfferCode); cmd.Parameters.AddWithValue("@StartDate", offer.StartDate); cmd.Parameters.AddWithValue("@EndDate", offer.EndDate); cmd.Parameters.AddWithValue("@OfferValue", offer.OfferValue); cmd.Parameters.AddWithValue("@AppliesToID", offer.AppliesToID); cmd.Parameters.AddWithValue("@OfferTypeID", offer.OfferTypeID); cmd.Parameters.AddWithValue("@CategoryID", offer.CategoryID); cmd.Parameters.AddWithValue("@ItemGroupID", offer.ItemGroupID); cmd.Parameters.AddWithValue("@IsActive", offer.IsActive); cmd.Parameters.AddWithValue("@UserID", offer.UserID); object objreturn = cmd.ExecuteScalar(); if (!int.TryParse(objreturn.ToString(), out OfferID)) { throw new Exception("Error while saivng offer"); } } } catch (Exception ex) { throw new Exception("Error While saving offer", ex); } finally { SQLCon.Sqlconn().Close(); } return(OfferID); }
/// <summary> /// Code to save Role and feature mapping /// </summary> /// <param name="ObjEUserInfo"></param> /// <param name="dt"></param> /// <returns></returns> public EUserInfo SaveFeatureMap(EUserInfo ObjEUserInfo, DataTable dt) { DataSet dsFeature = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_RoleFeatureMap]"; cmd.Parameters.Add("@RoleID", ObjEUserInfo.RoleID); cmd.Parameters.Add("@dtFeatureMap", dt); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsFeature); } if (dsFeature != null && dsFeature.Tables.Count > 0) { ObjEUserInfo.dtFeature = dsFeature.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler bei der Zuordnung einer Berechtigung zu einer Rolle"); } else { throw new Exception("Error Occured While Mapping Features To Role"); } } finally { SQLCon.Close(); } return(ObjEUserInfo); }
public StockDispatchDetail SaveDispatchDetail(StockDispatchDetail ObjStockDispatchDetail) { int StockDispatchDetailID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_STOCKDISPATCHDETAIL]"; cmd.Parameters.AddWithValue("@STOCKDISPATCHDETAILID", ObjStockDispatchDetail.STOCKDISPATCHDETAILID); cmd.Parameters.AddWithValue("@STOCKDISPATCHID", ObjStockDispatchDetail.STOCKDISPATCHID); cmd.Parameters.AddWithValue("@ITEMPRICEID", ObjStockDispatchDetail.ITEMPRICEID); cmd.Parameters.AddWithValue("@TRAYNUMBER", ObjStockDispatchDetail.TRAYNUMBER); cmd.Parameters.AddWithValue("@DISPATCHQUANTITY", ObjStockDispatchDetail.DISPATCHQUANTITY); cmd.Parameters.AddWithValue("@WEIGHTINKGS", ObjStockDispatchDetail.WEIGHTINKGS); cmd.Parameters.AddWithValue("@USERID", ObjStockDispatchDetail.UserID); object objReturn = cmd.ExecuteScalar(); string str = Convert.ToString(objReturn); if (!int.TryParse(str, out StockDispatchDetailID)) { throw new Exception(str); } else { ObjStockDispatchDetail.STOCKDISPATCHDETAILID = StockDispatchDetailID; } } } catch (Exception ex) { throw new Exception("Error While Saving Dispatch Detail"); } finally { SQLCon.Sqlconn().Close(); } return(ObjStockDispatchDetail); }
/// <summary> /// Code to fetch feature list from database /// </summary> /// <param name="ObjEUserInfo"></param> /// <returns></returns> public EUserInfo GetFeatureDetails(EUserInfo ObjEUserInfo) { DataSet dsFeature = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_Feature]"; cmd.Parameters.Add("@RoleID", ObjEUserInfo.RoleID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsFeature); } if (dsFeature != null && dsFeature.Tables.Count > 0) { ObjEUserInfo.dtFeature = dsFeature.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden von Daten"); } else { throw new Exception("Error Occured While Retreiving Features"); } } finally { SQLCon.Close(); } return(ObjEUserInfo); }
public DataSet GetUserCredentials(string UserName, string Password) { DataSet dSUser = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_R_USERLOGIN]"; cmd.Parameters.AddWithValue("@USERNAME", UserName); cmd.Parameters.AddWithValue("@PASSWORD", Password); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dSUser); } if (dSUser != null && dSUser.Tables[0].Rows.Count > 0) { int Ivalue = 0; string str = Convert.ToString(dSUser.Tables[0].Rows[0][0]); if (!int.TryParse(str, out Ivalue)) { throw new Exception(str); } } else { throw new Exception("Error in login"); } } } catch (Exception ex) { throw ex; } finally { SQLCon.Sqlconn().Close(); } return(dSUser); }
/// <summary> /// Code to get Formblatt 221 table 2 values /// </summary> /// <param name="ObjEFormBlatt"></param> /// <returns></returns> public EFormBlatt Get_tbl221_2(EFormBlatt ObjEFormBlatt) { try { DataSet ds = new DataSet(); ObjEFormBlatt.dtBlatt221_2 = new DataTable(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_tbl221_2]"; cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } if (ds != null && ds.Tables.Count > 0) { ObjEFormBlatt.dtBlatt221_2 = ds.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Laden der Generellen Kosten"); } else { throw new Exception("Error while retrieving form blatt"); } } finally { SQLCon.Close(); } return(ObjEFormBlatt); }
/// <summary> /// Code to fetch report settings from database /// </summary> /// <param name="ObjEObject"></param> /// <returns></returns> public DataSet GetReportSettings(EReportDesign ObjEReportDesign) { DataSet dsReportSetting = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ReportSetting]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsReportSetting); } if (dsReportSetting != null && dsReportSetting.Tables.Count > 0) { ObjEReportDesign.dtReportSettings = dsReportSetting.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Daten"); } else { throw new Exception("Error Occured While Retreiving the data"); } } finally { SQLCon.Close(); } return(dsReportSetting); }
public void DeleteInvoiceDetail(object StockEntryDetailID) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_D_STOCKENTRYDETAIL]"; cmd.Parameters.AddWithValue("@STOCKENTRYDETAILID", StockEntryDetailID); object objReturn = cmd.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception("Error While Deleting Invoice Detail"); } finally { SQLCon.Sqlconn().Close(); } }
public void UpdateDispatch(StockDispatch ObjStockDispatch) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_U_STOCKDISPATCH]"; cmd.Parameters.AddWithValue("@STOCKDISPATCHID", ObjStockDispatch.STOCKDISPATCHID); cmd.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception("Error While Updating Dispatch"); } finally { SQLCon.Sqlconn().Close(); } }
/// <summary> /// Code to fetch access levels for selected role /// </summary> /// <param name="ObjEUserInfo"></param> /// <returns></returns> public EUserInfo GetAceesLevels(EUserInfo ObjEUserInfo) { DataSet dsAccessLevels = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_AccessLevels]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsAccessLevels); } if (dsAccessLevels != null && dsAccessLevels.Tables.Count > 0) { ObjEUserInfo.dtAccessLevels = dsAccessLevels.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Zugangsinformationen"); } else { throw new Exception("Error Occured While Retreiving Access Levels"); } } finally { SQLCon.Close(); } return(ObjEUserInfo); }
public StockDispatch SaveDispatch(StockDispatch ObjStockDispatch) { int StockDispatchID = 0; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_CU_STOCKDISPATCH]"; cmd.Parameters.AddWithValue("@STOCKDISPATCHID", ObjStockDispatch.STOCKDISPATCHID); cmd.Parameters.AddWithValue("@FROMBRANCHID", ObjStockDispatch.FROMBRANCHID); cmd.Parameters.AddWithValue("@TOBRANCHID", ObjStockDispatch.TOBRANCHID); cmd.Parameters.AddWithValue("@CATEGORYID", ObjStockDispatch.CATEGORYID); cmd.Parameters.AddWithValue("@USERID", ObjStockDispatch.UserID); object objReturn = cmd.ExecuteScalar(); string str = Convert.ToString(objReturn); if (!int.TryParse(str, out StockDispatchID)) { throw new Exception(str); } else { ObjStockDispatch.STOCKDISPATCHID = objReturn; } } } catch (Exception ex) { throw new Exception("Error While Saving Dispatch"); } finally { SQLCon.Sqlconn().Close(); } return(ObjStockDispatch); }
/// <summary> /// Code to fetch Positions from database for bulk proccess module by filtering with article /// </summary> /// <param name="ProjectID"></param> /// <param name="tType"></param> /// <param name="dt"></param> /// <returns></returns> public DataSet GetPsoitionOZByWGWA(int ProjectID, string tType, string WG, string WA) { DataSet dsPositionsOZList = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_PositionOZ]"; cmd.Parameters.AddWithValue("@ProjectID", ProjectID); cmd.Parameters.AddWithValue("@Position_Type", tType); cmd.Parameters.AddWithValue("@WG", WG); cmd.Parameters.AddWithValue("@WA", WA); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsPositionsOZList, "Positions"); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Positionsliste"); } else { throw new Exception("Error Occured While Retreiving Position OZ List"); } } finally { SQLCon.Close(); } return(dsPositionsOZList); }
/// <summary> /// Code to get Cost types /// </summary> /// <param name="ObjEFormBlatt"></param> /// <returns></returns> public EFormBlatt GetFormBlatttype(EFormBlatt ObjEFormBlatt) { DataSet dsFormBlatt = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_FormBlattType]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsFormBlatt); } if (dsFormBlatt != null && dsFormBlatt.Tables.Count > 0) { ObjEFormBlatt.dtBlattTypes = dsFormBlatt.Tables[0]; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Ein Fehler ist aufgetreten beim Laden des Formulars (Kostentypen)"); } else { throw new Exception("Error Occured While Retreiving Access FormBlatt Types"); } } finally { SQLCon.Close(); } return(ObjEFormBlatt); }
public DataTable GetPositionKZ() { DataTable dt = null; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_PositionList]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } } } catch (Exception ex) { throw; } return(dt); }
/// <summary> /// Code to get Project specific Articles /// </summary> /// <param name="ObjEPositon"></param> /// <returns></returns> public EPosition GetProjectArticles(EPosition ObjEPositon) { try { ObjEPositon.dtProjectArticles = new DataTable(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ProjectArticles]"; cmd.Parameters.AddWithValue("@ProjectID", ObjEPositon.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ObjEPositon.dtProjectArticles); } } } catch (Exception ex) { throw; } return(ObjEPositon); }
public void ResetPassword(object UserID, string PasswordString) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[USP_U_CHANGEPASSWORD]"; cmd.Parameters.AddWithValue("@USERID", UserID); cmd.Parameters.AddWithValue("@PASSWORDSTRING", PasswordString); if (cmd.ExecuteNonQuery() == 0) { throw new Exception("Error while resetting the password"); } } } catch (Exception ex) { throw ex; } finally { SQLCon.Sqlconn().Close(); } }
/// <summary> /// Code to save Cost type mapping with articles /// </summary> /// <param name="ObjEFormBlatt"></param> /// <param name="_dt"></param> /// <returns></returns> public EFormBlatt Save_FormBlattArticles(EFormBlatt ObjEFormBlatt, DataTable _dt) { DataSet dsFormBlattArticle = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_FormBlattarticles]"; cmd.Parameters.Add("@LookupID", ObjEFormBlatt.LookUpID); cmd.Parameters.Add("@dtBlattArticles", _dt); cmd.Parameters.Add("@ProjectID", ObjEFormBlatt.ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsFormBlattArticle); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Ein Fehler ist aufgetreten beim Speichern des Formulars"); } else { throw new Exception("Error Occured While Saving Titles Articles"); } } finally { SQLCon.Close(); } return(ObjEFormBlatt); }