// This method displays the Dealers Logo. public void show() { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql; string filePath = ""; sql = "select Logo from Organisation where CompanyID='1001'"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { filePath = SqlDtr["Logo"].ToString(); } else { string home_drive = Environment.SystemDirectory; home_drive = home_drive.Substring(0, 2); filePath = home_drive + @"\Inetpub\wwwroot\Servosms\CompanyLogo\Logo.jpg"; } if (filePath.Trim().Equals("")) { string home_drive = Environment.SystemDirectory; home_drive = home_drive.Substring(0, 2); filePath = home_drive + @"\Inetpub\wwwroot\Servosms\CompanyLogo\Logo.jpg"; } imgSample.ImageUrl = filePath; SqlDtr.Close(); }
public IHttpActionResult SeqStockMaster(string str1) { try { SqlDataReader SqlDtr; StockAdjustmentModel stkadj = new StockAdjustmentModel(); string sql; sql = "select * from Stock_Master where Productid='" + str1 + "' order by Stock_date"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { controlopening_stock.Add(SqlDtr["opening_stock"].ToString()); controlreceipt.Add(SqlDtr["receipt"].ToString()); controlsales.Add(SqlDtr["sales"].ToString()); controlsalesfoc.Add(SqlDtr["salesfoc"].ToString()); controlProductid.Add(SqlDtr["Productid"].ToString()); controlstock_date.Add(SqlDtr["stock_date"].ToString()); } SqlDtr.Close(); stkadj.opening_stock = controlopening_stock; stkadj.receipt = controlreceipt; stkadj.sales = controlsales; stkadj.salesfoc = controlsalesfoc; stkadj.Productid = controlProductid; stkadj.stock_date = controlstock_date; return(Ok(stkadj)); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, "Route could not update.")); } }
public IHttpActionResult GetNextRoleID() { string roleID = string.Empty; try { #region Fetch Next Role ID string sql = "select max(Role_ID)+1 from Roles"; SqlDataReader SqlDtr; EmployeeClass obj = new EmployeeClass(); SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { roleID = SqlDtr.GetSqlValue(0).ToString(); } SqlDtr.Close(); #endregion if (roleID == null) { return(Content(HttpStatusCode.NotFound, "Failed to get Next Role ID.")); } return(Ok(roleID)); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, "Failed to get Next Role ID.")); } }
public string GetNextPeriodID() { try { Next_Period_Id = "1"; InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql = " Select max(Period_Id)+1 Next_Id from Cust_Sale_MS_HSD"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { if (SqlDtr["Next_Id"].ToString() != null && SqlDtr["Next_Id"].ToString() != "") { Next_Period_Id = SqlDtr["Next_Id"].ToString(); } else { Next_Period_Id = "1"; } } SqlDtr.Close(); return(Next_Period_Id); } catch (Exception ex) { return(Next_Period_Id); } }