private Int64 SaveRecord()
{
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = new AccessUserDetails();
clsDetails.UserName = txtUserName.Text;
clsDetails.Password = txtPassword.Text;
clsDetails.Name = txtName.Text;
clsDetails.CountryID = Convert.ToInt32(cboCountry.SelectedItem.Value);
clsDetails.Address1 = txtAddress1.Text;
clsDetails.Address2 = txtAddress2.Text;
clsDetails.City = txtCity.Text;
clsDetails.State = txtState.Text;
clsDetails.OfficePhone = txtOfficePhone.Text;
clsDetails.DirectPhone = txtDirectPhone.Text;
clsDetails.HomePhone = txtHomePhone.Text;
clsDetails.FaxPhone = txtFaxNumber.Text;
clsDetails.MobilePhone = txtMobile.Text;
clsDetails.EmailAddress = txtEmail.Text;
clsDetails.GroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
Int64 id = clsAccessUser.Insert(clsDetails);
clsAccessUser.CommitAndDispose();
return(id);
}
private void LoadRecord()
{
long iID = long.Parse(Common.Decrypt(Request.QueryString["id"].ToString(), Session.SessionID));
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = clsAccessUser.Details(iID);
clsAccessUser.CommitAndDispose();
lblUID.Text = clsDetails.UID.ToString();
txtUserName.Text = clsDetails.UserName;
txtPassword.Text = clsDetails.Password;
txtConfirm.Text = clsDetails.Password;
txtName.Text = clsDetails.Name;
cboCountry.SelectedIndex = cboCountry.Items.IndexOf(cboCountry.Items.FindByValue(clsDetails.CountryID.ToString()));
txtAddress1.Text = clsDetails.Address1;
txtAddress2.Text = clsDetails.Address2;
txtCity.Text = clsDetails.City;
txtState.Text = clsDetails.State;
txtOfficePhone.Text = clsDetails.OfficePhone;
txtDirectPhone.Text = clsDetails.DirectPhone;
txtHomePhone.Text = clsDetails.HomePhone;
txtFaxNumber.Text = clsDetails.FaxPhone;
txtMobile.Text = clsDetails.MobilePhone;
txtEmail.Text = clsDetails.EmailAddress.ToString();
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(clsDetails.GroupID.ToString()));
txtPageSize.Text = clsDetails.PageSize.ToString();
}
private void SaveRecord()
{
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = new AccessUserDetails();
clsDetails.UID = Convert.ToInt64(lblUID.Text);
clsDetails.UserName = txtUserName.Text;
clsDetails.Password = txtPassword.Text;
clsDetails.Name = txtName.Text;
clsDetails.CountryID = Convert.ToInt32(cboCountry.SelectedItem.Value);
clsDetails.Address1 = txtAddress1.Text;
clsDetails.Address2 = txtAddress2.Text;
clsDetails.City = txtCity.Text;
clsDetails.State = txtState.Text;
clsDetails.OfficePhone = txtOfficePhone.Text;
clsDetails.DirectPhone = txtDirectPhone.Text;
clsDetails.HomePhone = txtHomePhone.Text;
clsDetails.FaxPhone = txtFaxNumber.Text;
clsDetails.MobilePhone = txtMobile.Text;
clsDetails.EmailAddress = txtEmail.Text;
clsDetails.GroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.PageSize = Convert.ToInt32(txtPageSize.Text);
clsAccessUser.Update(clsDetails);
clsAccessUser.CommitAndDispose();
AssignUserSession(clsDetails);
}
private string CloseInventory()
{
string strRetValue = "";
try
{
DateTime DeliveryDate = Convert.ToDateTime(txtClosingDate.Text);
ERPConfig clsERPConfig = new ERPConfig();
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate)
{
string strReferenceNo = Constants.CLOSE_INVENTORY_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsERPConfig.get_LastClosingNo();
AccessUserDetails clsAccessUserDetails = (AccessUserDetails)Session["AccessUserDetails"];
ProductInventories clsProductInventories = new ProductInventories(clsERPConfig.Connection, clsERPConfig.Transaction);
clsProductInventories.CloseInventoryBySupplier(int.Parse(cboBranch.SelectedItem.Value), clsAccessUserDetails.UID, DateTime.Parse(txtClosingDate.Text), strReferenceNo, long.Parse(cboContact.SelectedItem.Value), cboContact.SelectedItem.Text);
Products clsProducts = new Products(clsERPConfig.Connection, clsERPConfig.Transaction);
clsProducts.LockUnlockForSellingBySupplier(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboContact.SelectedItem.Value), false);
clsERPConfig.CommitAndDispose();
strRetValue = strReferenceNo;
}
else
{
clsERPConfig.CommitAndDispose();
string stScript = "<Script>";
stScript += "window.alert('Sorry you cannot close using the closing date: " + txtClosingDate.Text + ". Please enter an allowable posting date.')";
stScript += "</Script>";
Response.Write(stScript);
}
}
catch (Exception ex)
{
string stScript = "<Script>";
stScript += "window.alert('An error has occured while closing the inventory. Details:' " + ex.Message + ")";
stScript += "</Script>";
Response.Write(stScript);
}
return(strRetValue);
}
private void AssignUserSession(AccessUserDetails clsDetails)
{
Session["AccessUserDetails"] = clsDetails;
// Session.RemoveAll();
Session.Add("PageSize", clsDetails.PageSize);
Session.Add("UID", clsDetails.UID);
Session.Add("UserName", clsDetails.UserName);
Session.Add("Password", clsDetails.Password);
Session.Add("Name", clsDetails.Name);
Session.Add("CountryID", clsDetails.CountryID);
Session.Add("Addres1", clsDetails.Address1);
Session.Add("Addres2", clsDetails.Address2);
Session.Add("City", clsDetails.City);
Session.Add("State", clsDetails.State);
Session.Add("OfficePhone", clsDetails.OfficePhone);
Session.Add("DirectPhone", clsDetails.DirectPhone);
Session.Add("HomePhone", clsDetails.HomePhone);
Session.Add("FaxPhone", clsDetails.FaxPhone);
Session.Add("MobilePhone", clsDetails.MobilePhone);
Session.Add("EmailAddress", clsDetails.EmailAddress);
}
public void AssignUserSession(Int64 UID)
{
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = clsAccessUser.Details(UID);
clsAccessUser.CommitAndDispose();
Session.RemoveAll();
Session.Add("BranchID", Constants.BRANCH_ID_MAIN);
Session.Add("TerminalNo", Constants.C_DEFAULT_TERMINAL_01);
Session.Add("AccessUserDetails", clsDetails);
Session.Add("PageSize", clsDetails.PageSize);
Session.Add("UID", UID);
Session.Add("UserName", clsDetails.UserName);
Session.Add("Password", clsDetails.Password);
Session.Add("Name", clsDetails.Name);
Session.Add("CountryID", clsDetails.CountryID);
Session.Add("Addres1", clsDetails.Address1);
Session.Add("Addres2", clsDetails.Address2);
Session.Add("City", clsDetails.City);
Session.Add("State", clsDetails.State);
Session.Add("OfficePhone", clsDetails.OfficePhone);
Session.Add("DirectPhone", clsDetails.DirectPhone);
Session.Add("HomePhone", clsDetails.HomePhone);
Session.Add("FaxPhone", clsDetails.FaxPhone);
Session.Add("MobilePhone", clsDetails.MobilePhone);
Session.Add("EmailAddress", clsDetails.EmailAddress);
//Data.SysConfig clsSysConfig = new Data.SysConfig();
//Session.Add(Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE, clsSysConfig.get_BackendVariationType());
//clsSysConfig.CommitAndDispose();
//overwrite the companydetails from the database
Data.SysConfig clsSysConfig = new Data.SysConfig();
Data.SysConfigDetails clsSysConfigDetails = clsSysConfig.get_SysConfigDetails();
clsSysConfig.CommitAndDispose();
Session.Add(Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE, clsSysConfigDetails.BACKEND_VARIATION_TYPE);
CompanyDetails.BECompanyCode = string.IsNullOrEmpty(clsSysConfigDetails.BECompanyCode) ? CompanyDetails.BECompanyCode : clsSysConfigDetails.BECompanyCode;
CompanyDetails.CompanyCode = string.IsNullOrEmpty(clsSysConfigDetails.CompanyCode) ? CompanyDetails.CompanyCode : clsSysConfigDetails.CompanyCode;
CompanyDetails.CompanyName = string.IsNullOrEmpty(clsSysConfigDetails.CompanyName) ? CompanyDetails.CompanyName : clsSysConfigDetails.CompanyName;
CompanyDetails.Currency = string.IsNullOrEmpty(clsSysConfigDetails.Currency) ? CompanyDetails.Currency : clsSysConfigDetails.Currency;
CompanyDetails.TIN = string.IsNullOrEmpty(clsSysConfigDetails.TIN) ? CompanyDetails.TIN : clsSysConfigDetails.TIN;
CompanyDetails.Address1 = string.IsNullOrEmpty(clsSysConfigDetails.Address1) ? CompanyDetails.Address1 : clsSysConfigDetails.Address1;
CompanyDetails.Address2 = string.IsNullOrEmpty(clsSysConfigDetails.Address2) ? CompanyDetails.Address2 : clsSysConfigDetails.Address2;
CompanyDetails.City = string.IsNullOrEmpty(clsSysConfigDetails.City) ? CompanyDetails.City : clsSysConfigDetails.City;
CompanyDetails.State = string.IsNullOrEmpty(clsSysConfigDetails.State) ? CompanyDetails.State : clsSysConfigDetails.State;
CompanyDetails.Zip = string.IsNullOrEmpty(clsSysConfigDetails.Zip) ? CompanyDetails.Zip : clsSysConfigDetails.Zip;
CompanyDetails.Country = string.IsNullOrEmpty(clsSysConfigDetails.Country) ? CompanyDetails.Country : clsSysConfigDetails.Country;
CompanyDetails.OfficePhone = string.IsNullOrEmpty(clsSysConfigDetails.OfficePhone) ? CompanyDetails.OfficePhone : clsSysConfigDetails.OfficePhone;
CompanyDetails.DirectPhone = string.IsNullOrEmpty(clsSysConfigDetails.DirectPhone) ? CompanyDetails.DirectPhone : clsSysConfigDetails.DirectPhone;
CompanyDetails.FaxPhone = string.IsNullOrEmpty(clsSysConfigDetails.FaxPhone) ? CompanyDetails.FaxPhone : clsSysConfigDetails.FaxPhone;
CompanyDetails.MobilePhone = string.IsNullOrEmpty(clsSysConfigDetails.MobilePhone) ? CompanyDetails.MobilePhone : clsSysConfigDetails.MobilePhone;
CompanyDetails.EmailAddress = string.IsNullOrEmpty(clsSysConfigDetails.EmailAddress) ? CompanyDetails.EmailAddress : clsSysConfigDetails.EmailAddress;
CompanyDetails.WebSite = string.IsNullOrEmpty(clsSysConfigDetails.WebSite) ? CompanyDetails.WebSite : clsSysConfigDetails.WebSite;
}
protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Administration Files";
string stHeading = defaultHeading;
const string defaultTitle = "RetailPlus System Security Administration";
SiteTitle.Title = defaultTitle;
const SearchCategoryID defaultSearchIndex = SearchCategoryID.AccessUsers;
SearchCategoryID SearchIndex = defaultSearchIndex;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.AdministrationFiles;
if (Request.QueryString["task"] != null)
{
string task = Common.Decrypt(Request.QueryString["task"].ToString(), Session.SessionID);
switch (task)
{
case "add":
stHeading = "Create New Access User";
SearchIndex = SearchCategoryID.AccessUsers;
ctrlInsert.Visible = true;
break;
case "edit":
stHeading = "Modify Access User";
SearchIndex = SearchCategoryID.AccessUsers;
ctrlUpdate.Visible = true;
break;
case "list":
stHeading = "Access User List";
SearchIndex = SearchCategoryID.AccessUsers;
ctrlList.Visible = true;
break;
case "accessrights":
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
AccessUser clsAccessUser = new AccessUser();
AccessUserDetails clsDetails = clsAccessUser.Details(iID);
clsAccessUser.CommitAndDispose();
stHeading = "Update access rights of <b>" + clsDetails.Name + "</b>";
SearchIndex = SearchCategoryID.AccessUsers;
ctrlAccessRights.Visible = true;
break;
case "custom":
stHeading = "Customize your account.";
SearchIndex = SearchCategoryID.NotApplicable;
ctrlAccount.Visible = true;
break;
case "details":
stHeading = "Account Details";
SearchIndex = SearchCategoryID.AccessUsers;
ctrlDetails.Visible = true;
break;
default:
break;
}
LargeHeading.Text = stHeading;
RightBodySectionSearch.SearchIDSelectedItem = SearchIndex;
}
}
