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