//**************
/// <summary>
/// This method is used to get the nextID auto.
/// </summary>
public void GetNextschemeID()
{
try
{
PartiesClass obj = new PartiesClass();
SqlDataReader SqlDtr;
#region Fetch Next scheme ID
SqlDtr = obj.GetNextFOID();
while (SqlDtr.Read())
{
lblschid.Text = SqlDtr.GetSqlValue(0).ToString();
if (lblschid.Text == "Null")
{
lblschid.Text = "100001";
}
}
SqlDtr.Close();
#endregion
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:fleet/oe discountEntry.aspx,Class:PartiesClass.cs: Method:GetNextschemeID(). EXCEPTION " + ex.Message + " User " + uid);
}
}
/// <summary>
/// This method is used to generate the next user id
/// </summary>
public void GetNextUserID()
{
EmployeeClass obj = new EmployeeClass();
SqlDataReader SqlDtr;
string sql;
try
{
#region Fetch Next User ID
sql = "select max(UserID)+1 from User_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
lblUserID.Text = SqlDtr.GetSqlValue(0).ToString();
if (lblUserID.Text == "Null")
{
lblUserID.Text = "1001";
}
}
SqlDtr.Close();
#endregion
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:User_Profile.aspx,Method:GetNextUserID EXCEPTION: " + ex.Message + " " + uid);
}
}
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."));
}
}
/// <summary>
/// Method to fetch the Next Employee ID from table employee and display in lable.
/// The ID initially starts with 1001.
/// </summary>
public void GetNextEmpID()
{
EmployeeClass obj = new EmployeeClass();
SqlDataReader SqlDtr;
#region Fetch Next Employee ID
SqlDtr = obj.GetNextEmployeeID();
while (SqlDtr.Read())
{
LblEmployeeID.Text = SqlDtr.GetSqlValue(0).ToString();
if (LblEmployeeID.Text == "Null")
{
LblEmployeeID.Text = "9001";
}
}
SqlDtr.Close();
#endregion
}
/// <summary>
/// This method is used to returns the Next Supplier ID from table Supplier.
/// </summary>
public void GetNextSupplierID()
{
PartiesClass obj = new PartiesClass();
SqlDataReader SqlDtr;
#region Fetch Next Vendor ID
SqlDtr = obj.GetNextSupplierID();
while (SqlDtr.Read())
{
lblSupplierID.Text = SqlDtr.GetSqlValue(0).ToString();
if (lblSupplierID.Text == "Null")
{
lblSupplierID.Text = "1001";
}
}
SqlDtr.Close();
#endregion
}
/// <summary>
/// This is used to generate next CompanyID auto.
/// </summary>
public void GetNextCustomerID()
{
PartiesClass obj = new PartiesClass();
SqlDataReader SqlDtr;
#region Fetch Next Customer ID
SqlDtr = obj.GetNextCustomerID1();
while (SqlDtr.Read())
{
LblCompanyID.Text = SqlDtr.GetSqlValue(0).ToString();
if (LblCompanyID.Text == "Null")
{
LblCompanyID.Text = "1001";
}
}
SqlDtr.Close();
#endregion
}
public IHttpActionResult GetNextID()
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string customerID = "";
#region Fetch Next Customer ID
string sql = "select max(Cust_ID)+1 from Customer";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
customerID = SqlDtr.GetSqlValue(0).ToString();
if (customerID == "Null")
{
customerID = "1001";
}
}
SqlDtr.Close();
#endregion
return(Ok(customerID));
}
public string GetNextUserID()
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string sql;
string userID = null;
#region Fetch Next User ID
sql = "select max(UserID)+1 from User_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
userID = SqlDtr.GetSqlValue(0).ToString();
if (userID == null)
{
userID = "1001";
}
}
SqlDtr.Close();
#endregion
return(userID);
}
