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