public ActionResult CreateTest(Test model)
{
int result = 0;
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
result = BALUser.AddTest(model, domainName);
}
switch (result)
{
case -1:
TempData["message"] = "Test Name already exists for same date.";
TempData["IsSuccess"] = 0;
break;
case 0:
TempData["message"] = "Something went wrong.";
TempData["IsSuccess"] = 0;
break;
case 1:
TempData["message"] = "Record successfully inserted.";
TempData["IsSuccess"] = 1;
break;
case 2:
TempData["message"] = "Record successfully updated.";
TempData["IsSuccess"] = 1;
break;
}
return(RedirectToAction("Index"));
}
public IActionResult AthleteList(int?id)
{
AthleteModel model = new AthleteModel();
string message = string.Empty;
try
{
model.athleteList = BALUser.GetAthletesByTypeId(id.ToSafeInt(), _configuration["DomainName"].ToSafeString());
model.TestId = id.ToSafeInt();
if (TempData["message"] != null)
{
message = TempData["message"].ToSafeString();
ViewBag.Message = message;
if (TempData["IsSuccess"].ToSafeInt() == 0)
{
ViewBag.IsError = 1;
}
else
{
ViewBag.IsForgotPwdSucc = 1;
}
}
}
catch (System.Exception)
{
throw;
}
return(View(model));
}
private void BindCustomerDetails()
{
BALUser objBALUser = new BALUser();
try
{
gdvCustomer.PageSize = int.Parse(ViewState["ps"].ToString());
DataSet objds = objBALUser.GetUserDetails(0);
Session["dt"] = objds.Tables[0];
if (objds.Tables[0].Rows.Count > 0)
{
string sortDirection = "ASC", sortExpression;
if (ViewState["so"] != null)
{
sortDirection = ViewState["so"].ToString();
}
if (ViewState["se"] != null)
{
sortExpression = ViewState["se"].ToString();
objds.Tables[0].DefaultView.Sort = sortExpression + " " + sortDirection;
}
gdvCustomer.DataSource = objds.Tables[0];
gdvCustomer.DataBind();
}
else
{
gdvCustomer.DataSource = null;
gdvCustomer.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
BALUser balJoueur = new BALUser();
try
{
int returnValue = balJoueur.CreateUser(this.UserName.Text, this.Email.Text, this.Password.Text);
if (returnValue > 0)
{
Page.RegisterClientScriptBlock("message", "<script>alert('Joueur is created successfully')</script>");
Session["User"] = this.UserName.Text;
//binding(null);
}
else
{
Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect User Inputs.')</script>");
}
}
catch (Exception ex)
{
clsLogging logError = new clsLogging();
logError.WriteLog(ex);
}
}
public void DeleteUser(BALUser obj)
{
query = "delete from [User] where UserId=" + obj.UserId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateUser(BALUser obj)
{
query = "update [User] set FirstName='" + obj.FirstName + "',LastName='" + obj.LastName + "',Address='" + obj.Address+"',Mobile='"+obj.Mobile+"',Gender='"+obj.Gender+"',Dob='"+obj.DateOfBirth+"',LoginId="+obj.LoginId+"where UserId="+obj.UserId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
private void InsertUpdateCustomer()
{
try
{
BALUser objBALUser = new BALUser();
UserEntity objUserEntity = new UserEntity();
objUserEntity.user_master_id = Convert.ToInt32(hfUserId.Value);
objUserEntity.RoleId = Convert.ToInt32(dropUserType.SelectedValue);
objUserEntity.LocationId = Convert.ToInt32(dropLocation.SelectedValue);
objUserEntity.user_master_status = Convert.ToInt32(dropStatus.SelectedValue);
//objUserEntity.IsLogin = bool.Parse(chkIsLogin.Text);
objUserEntity.FirstName = txtFirstName.Text;
objUserEntity.LastName = txtLastName.Text;
objUserEntity.user_master_mobile = txtMobileNumber.Text;
objUserEntity.user_master_land = txtLandLineNumber.Text;
objUserEntity.user_master_mail = txtEmailId.Text;
objUserEntity.user_master_name = "";
objUserEntity.user_master_desc = "";
objUserEntity.user_master_address = "";
objUserEntity.user_master_contact_person = "";
objUserEntity.user_master_link = "";
if (fuUserImage.HasFile)
{
string str = fuUserImage.FileName;
fuUserImage.SaveAs(Server.MapPath("/Admin/CustomerImages/" + fuUserImage.FileName));
}
else
{
labelError.Text = "Please Select Image";
return;
}
objUserEntity.user_master_logo = fuUserImage.FileName;
objUserEntity.password = txtPassword.Text;
objUserEntity.user_name = txtEmailId.Text;
objUserEntity.password = txtConfirmPawd.Text;
objUserEntity.user_master_created_by = Session["loginId"].ToString();
int nResult = objBALUser.InsertUpdateUser(objUserEntity);
if (nResult == -1)
{
labelError.Text = "User already Exist";
}
if (nResult > 0)
{
Response.Redirect("CustomerList.aspx", true);
}
}
catch (Exception ex)
{
}
}
public DataSet getuserprofile(BALUser obj)
{
query="select * from [User] a inner join Login b on a.LoginId=b.LoginId where a.LoginId="+obj.LoginId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void InsertUser(BALUser obj)
{
// query = "insert into User (FirstName,LastName,Address,Mobile,Gender,Dob,LoginId) values ('" + obj.FirstName + "','" + obj.LastName + "','" + obj.Address + "','" + obj.Mobile + "','" + obj.Gender + "','" + obj.DateOfBirth + "'," + obj.LoginId + ")";
query = "insert into [User] (FirstName,LastName,Address,Mobile,Gender,Dob,LoginId) values ('"+obj.FirstName+"','"+obj.LastName+"','"+obj.Address+"','"+obj.Mobile+"','"+obj.Gender+"','"+obj.DateOfBirth+"',"+obj.LoginId+")";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
BALUser lclsUser = new BALUser();
lclsUser.UserName = Environment.UserName.ToString();
if (!IsPostBack)
{
BindCorporateMaster();
BindFacility();
}
}
public IActionResult CreateNewAthlete(AthleteModel model)
{
int result = 0;
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
AthleteTestMapping athleteTest = new AthleteTestMapping();
athleteTest.AthleteTestId = model.TestId.ToSafeInt();
athleteTest.AthleteId = model.AthleteId.ToSafeInt();
athleteTest.Distance = model.Distance;
if (model.IsEditMode)
{
result = BALUser.AddAthlete(athleteTest, domainName, 1, model.MapId.ToSafeInt());
}
else
{
result = BALUser.AddAthlete(athleteTest, domainName, 0, model.MapId.ToSafeInt());
}
switch (result)
{
case -1:
TempData["message"] = "Athlete already exists in this test.";
TempData["IsSuccess"] = 0;
break;
case 0:
TempData["message"] = "Something went wrong.";
TempData["IsSuccess"] = 0;
break;
case 1:
TempData["message"] = "Record successfully inserted.";
TempData["IsSuccess"] = 1;
break;
case 2:
TempData["message"] = "Record successfully updated.";
TempData["IsSuccess"] = 1;
break;
}
}
return(RedirectToAction("AthleteList", new { id = model.TestId }));
}
private void BindCorporateMaster()
{
BALUser lclsUser = new BALUser();
lclsUser.UserName = Environment.UserName.ToString();
DataSet ds = new DataSet();
//ds = lclsService.GetUserCredentials(lclsUser);
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// //DataTable dt = new DataTable();
// lclsUser.UserID = Convert.ToInt64(ds.Tables[0].Rows[0]["UserID"].ToString());
// lclsUser.UserRoleID = Convert.ToInt64(ds.Tables[0].Rows[0]["RoleID"].ToString());
// }
//}
//if (lclsUser.UserRoleID == 1)
//{
// Search Drop Down
drpcorp.DataSource = lclsService.GetCorporateMaster().ToList();
drpcorp.DataTextField = "CorporateName";
drpcorp.DataValueField = "CorporateID";
drpcorp.DataBind();
//drpcorsearch.Items.Insert(0, lst);
//drpcorsearch.SelectedIndex = 0;
//}
//else
//{
// List<BALUser> lstfacility = new List<BALUser>();
// lstfacility = lclsService.GetCorporateFacilityByUserID(lclsUser.UserID).ToList();
// drpcorp.DataSource = lstfacility.Select(a => new { a.CorporateID, a.CorporateName }).Distinct();
// drpcorp.DataTextField = "CorporateName";
// drpcorp.DataValueField = "CorporateID";
// drpcorp.DataBind();
//}
ListItem lst = new ListItem();
lst.Value = "0";
lst.Text = "--Select Corporate--";
drpcorp.Items.Insert(0, lst);
drpcorp.SelectedIndex = 0;
}
private void DoAutoLogin()
{
InventoryServiceClient lclsService = new InventoryServiceClient();
BALUser lcluser = new BALUser();
//bool IsUserExist = lclsService.IsUserExist(txtUsername.Text, txtPassword.Text);
lcluser.UserName = Context.User.Identity.Name.ToString();
DataSet ds = new DataSet();
ds = lclsService.GetUserCredentials(lcluser);
if (ds.Tables.Count > 0)
{
Response.Redirect("Login.aspx");
}
else
{
Response.Redirect(@"Account\SignOut.aspx");
}
}
public IActionResult Index()
{
List <Test> model = BALUser.GetTestList(_configuration["DomainName"].ToSafeString());
string message = string.Empty;
if (TempData["message"] != null)
{
message = TempData["message"].ToSafeString();
ViewBag.Message = message;
if (TempData["IsSuccess"].ToSafeInt() == 0)
{
ViewBag.IsError = 1;
}
else
{
ViewBag.IsForgotPwdSucc = 1;
}
}
return(View(model));
}
private void BindFacility()
{
BALUser lclsUser = new BALUser();
lclsUser.UserName = Environment.UserName.ToString();
DataSet ds = new DataSet();
//ds = lclsService.GetUserCredentials(lclsUser);
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// //DataTable dt = new DataTable();
// lclsUser.UserID = Convert.ToInt64(ds.Tables[0].Rows[0]["UserID"].ToString());
// lclsUser.UserRoleID = Convert.ToInt64(ds.Tables[0].Rows[0]["RoleID"].ToString());
// }
//}
//if (lclsUser.UserRoleID == 1)
//{
drpfacility.DataSource = lclsService.GetCorporateFacility(Convert.ToInt64(drpcorp.SelectedValue)).Where(a => a.IsActive == true).ToList();
drpfacility.DataTextField = "FacilityDescription";
drpfacility.DataValueField = "FacilityID";
drpfacility.DataBind();
//}
//else
//{
// drpfacility.DataSource = lclsService.GetCorporateFacilityByUserID(lclsUser.UserID).Where(a => a.CorporateName == drpcorp.SelectedItem.Text).ToList();
// drpfacility.DataTextField = "FacilityName";
// drpfacility.DataValueField = "FacilityID";
// drpfacility.DataBind();
//}
ListItem lst = new ListItem();
lst.Value = "0";
lst.Text = "--Select Facility--";
drpfacility.Items.Insert(0, lst);
drpfacility.SelectedIndex = 0;
}
public IActionResult CreateAthlete(int?testId, int?athleteId)
{
AthleteModel model = new AthleteModel();
Test test = new Test();
AthleteTestMapping athleteTestMapping = new AthleteTestMapping();
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
if (testId.HasValue && athleteId.ToSafeInt() == 0)
{
model.TestId = testId.ToSafeInt();
model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName);
test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName);
model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd");
model.IsEditMode = false;
}
else
{
model.TestId = testId.ToSafeInt();
model.userList = BALUser.GetUserListByRoleId((int)Enums.UserRole.Athlete, domainName);
test = BALUser.GetTestTypeByTestId(testId.ToSafeInt(), domainName);
model.TestName = test.TestName.ToSafeString() + " " + test.TestDate.ToString("yyyy/MM/dd");
athleteTestMapping = BALUser.GetAthlete(athleteId.ToSafeInt(), domainName);
if (athleteTestMapping != null)
{
model.AthleteId = athleteTestMapping.AthleteId.ToSafeInt();
model.Distance = athleteTestMapping.Distance;
model.IsEditMode = true;
model.MapId = athleteTestMapping.MapId.ToSafeInt();
}
}
}
return(PartialView("~/Views/Home/AddAthlete.cshtml", model));
}
public IActionResult DeleteTest(AthleteModel model)
{
int result = 0;
string domainName = _configuration["DomainName"].ToSafeString();
if (!string.IsNullOrEmpty(domainName))
{
result = BALUser.DeleteTest(model.TestId.ToSafeInt(), domainName);
switch (result)
{
case 0:
TempData["message"] = "Something went wrong.";
TempData["IsSuccess"] = 0;
break;
case 1:
TempData["message"] = "Record successfully deleted.";
TempData["IsSuccess"] = 1;
break;
}
}
return(RedirectToAction("Index"));
}
//private void BindFacility()
//{
// drpfacility.DataSource = lclsService.GetFacility().ToList();
// drpfacility.DataTextField = "FacilityName";
// drpfacility.DataValueField = "FacilityID";
// drpfacility.DataBind();
// ListItem lst = new ListItem();
// lst.Value = "0";
// lst.Text = "--Select Facility--";
// drpfacility.Items.Insert(0, lst);
// drpfacility.SelectedIndex = 0;
//}
protected void btnlogin_Click(object sender, EventArgs e)
{
InventoryServiceClient lclsService = new InventoryServiceClient();
BALUser lclsUser = new BALUser();
lclsUser.FacilityID = Convert.ToInt64(drpfacility.SelectedValue);
lclsUser.UserName = txtemail.Text;
lclsUser.Password = txtpwd.Text;
lclsUser.CorporateID = Convert.ToInt64(drpcorp.SelectedValue);
List <GetLoginDetails> lstloginuser = lclsService.GetLoginDetails(lclsUser).ToList();
if (lstloginuser.Count != 0)
{
defaultPageControls.UserId = lstloginuser[0].UserID;
defaultPageControls.UserName = lstloginuser[0].UserName;
defaultPageControls.FacilityID = Convert.ToInt64(lstloginuser[0].FacilityID);
defaultPageControls.RoleID = Convert.ToInt64(lstloginuser[0].RoleID);
defaultPageControls.UserRoleName = lstloginuser[0].UserRoleName;
defaultPageControls.CorporateID = Convert.ToInt64(lstloginuser[0].CorporateID);
List <GetUserPagePermission> lstPermission = lclsService.GetLoginPermissionDetails(defaultPageControls.RoleID).ToList();
for (var i = 0; i < lstPermission.Count; i++)
{
switch (Convert.ToInt32(lstPermission[i].MainMenuID))
{
case 1:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 1:
defaultPageControls.Req_MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 2:
defaultPageControls.Req_WorkOrServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_WorkOrServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 3:
defaultPageControls.Req_MachinePartsPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_MachinePartsPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 4:
defaultPageControls.Req_RequestITPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_RequestITPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 5:
defaultPageControls.CapitalItemRequest_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CapitalItemRequest_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 2:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 5:
defaultPageControls.Rec_MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Rec_MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 6:
defaultPageControls.Rec_WorkOrServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Rec_WorkOrServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 7:
defaultPageControls.Rec_MachinePartsPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Rec_MachinePartsPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 8:
defaultPageControls.CapitalReceiving_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CapitalReceiving_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 30:
defaultPageControls.ITReceiving_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.ITReceiving_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 3:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 9:
defaultPageControls.StocksOrInventory_Ending_Page_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.StocksOrInventory_Ending_Page_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 10:
defaultPageControls.StocksOrInventory_Daily_Page_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.StocksOrInventory_Daily_Page_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 4:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 11:
defaultPageControls.CurrencyPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CurrencyPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 12:
defaultPageControls.CorporatePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CorporatePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 13:
defaultPageControls.FacilityPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.FacilityPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 14:
defaultPageControls.FacilityReligionPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.FacilityReligionPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 15:
defaultPageControls.ItemCategoryPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.ItemCategoryPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 16:
defaultPageControls.MedicalSuppliesPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.MedicalSuppliesPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 17:
defaultPageControls.UomMaster_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.UomMaster_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 18:
defaultPageControls.AddUserPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.AddUserPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 19:
defaultPageControls.UserPermission_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.UserPermission_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 20:
defaultPageControls.VendorPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.VendorPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
//case 21:
// defaultPageControls.VendorFacilityActPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
// defaultPageControls.VendorFacilityActPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
// break;
case 22:
defaultPageControls.VendorItemMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.VendorItemMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 23:
defaultPageControls.FacilityItemMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.FacilityItemMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 24:
defaultPageControls.VendorFacilityActPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.VendorFacilityActPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 25:
defaultPageControls.VendorOrderDue_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.VendorOrderDue_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 26:
defaultPageControls.FacilitySuppliesMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.FacilitySuppliesMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 27:
defaultPageControls.MachineMaster_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.MachineMaster_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 28:
defaultPageControls.CorpEquipmentMap_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CorpEquipmentMap_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 5:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 26:
defaultPageControls.TransferInPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.TransferInPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 27:
defaultPageControls.TransferOutPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.TransferOutPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
defaultPageControls.TransferOutPage_Email = Convert.ToBoolean(lstPermission[i].IsEmailNotification);
break;
case 28:
defaultPageControls.TransferHistoryPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.TransferHistoryPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 6:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 28:
defaultPageControls.VendorOrderDueRemainder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.VendorOrderDueRemainder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
case 7:
switch (Convert.ToInt32(lstPermission[i].SubMenuID))
{
case 1:
defaultPageControls.CapitalOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.CapitalOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 2:
defaultPageControls.Req_RequestITPOPage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_RequestITPOPage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 3:
defaultPageControls.Req_POServicePage_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.Req_POServicePage_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 4:
defaultPageControls.MachinePartsOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.MachinePartsOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
case 5:
defaultPageControls.MedicalSuppliesOrder_Edit = Convert.ToBoolean(lstPermission[i].IsEdit);
defaultPageControls.MedicalSuppliesOrder_View = Convert.ToBoolean(lstPermission[i].IsViewOnly);
break;
}
break;
}
}
Session["Permission"] = defaultPageControls;
Response.Redirect("Dashboard.aspx");
}
else
{
lblerror.Visible = true;
lblerror.Text = "Invalid UserName and Password";
}
}
private string UKZNCreateInvoice(string FileNo)
{
try
{
decimal TotalAmount = 0;
DataSet objDs = objBALFileManager.GetQuotationMasterByFileNo(FileNo);
string strMessage = string.Empty;
int ItemInvoiceNo = 0;
if (objDs.Tables[0].Rows.Count > 0)
{
int CreatedBy = Convert.ToInt32(Session["loginId"]);
int RoleId = Convert.ToInt32(Session["role_id"]);
int CompanyId = Convert.ToInt32(Session["CompanyId"]);
string QuotationRefNo = objDs.Tables[0].Rows[0]["QuotationMasterId"].ToString();
DataSet objDsQut = _objBOQutation.GetQuotationMasterDetailsWithRefNo(Convert.ToInt32(QuotationRefNo), RoleId, CompanyId, CreatedBy, "");
TravelRequestProcess objTravelRequest = new TravelRequestProcess();
List <UKZNInoviceDetails> LstObj = new List <UKZNInoviceDetails>();
int FlightRequestID = 0;
int HotelRequestId = 0;
int CabRequestId = 0;
if (objDsQut.Tables[0].Rows.Count > 0)// Flight Invoice
{
foreach (GridViewRow row in gdvFlightBookings.Rows)
{
CheckBox chk = row.FindControl("chkSelect") as CheckBox;
if (chk != null && chk.Checked)
{
foreach (DataRow QuotationRow in objDsQut.Tables[0].Rows)
{
ItemInvoiceNo = ItemInvoiceNo + 1;
UKZNInoviceDetails objF = new UKZNInoviceDetails();
objF.accountnumber = QuotationRow["AccountCode"].ToString();
objF.uniquerequestid = "F_" + QuotationRow["FlightRequestId"].ToString(); // QuotationRow["Fromcode"].ToString();
objF.invoiceitemnumber = ItemInvoiceNo.ToString(); // QuotationRow["FlightRequestId"].ToString();//"F_" + QuotationRow["FlightRequestId"].ToString();
objF.invoiceitemdescription = "Flight Item invoice created for file no" + FileNo;
objF.invoiceitemnote = "not paid";
objF.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString();
objF.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString();
objF.itemamountincvat = QuotationRow["TotalPrice"].ToString();
TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalPrice"].ToString());
objF.commentstmc = "Flight invoice created" + QuotationRow["FlightRequestId"].ToString();
objF.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objF.itemamountincvat), _decVarPercentage).ToString();
FlightRequestID = Convert.ToInt32(QuotationRow["FlightRequestId"]);
LstObj.Add(objF);
}
}
}
}
if (objDsQut.Tables[1].Rows.Count > 0)// Hotel Invoice
{
foreach (DataRow QuotationRow in objDsQut.Tables[1].Rows)
{
foreach (GridViewRow row in gdvHotelBooking.Rows)
{
CheckBox chk = row.FindControl("chkSelect") as CheckBox;
if (chk != null && chk.Checked)
{
ItemInvoiceNo = ItemInvoiceNo + 1;
UKZNInoviceDetails objH = new UKZNInoviceDetails();
objH.accountnumber = QuotationRow["AccountCode"].ToString();
objH.uniquerequestid = "A_" + QuotationRow["HotelRequestId"].ToString(); // QuotationRow["Fromcode"].ToString();
objH.invoiceitemdescription = "Hotel Item Invoice Created for file no" + FileNo;
objH.invoiceitemnumber = ItemInvoiceNo.ToString(); //"A_" + QuotationRow["HotelRequestId"].ToString();
objH.invoiceitemnote = "not paid";
objH.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString();
objH.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString();
objH.itemamountincvat = QuotationRow["TotalFee"].ToString();
objH.commentstmc = "Hotel Invoice Created" + QuotationRow["HotelRequestId"].ToString();
objH.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objH.itemamountincvat), _decVarPercentage).ToString();
TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalFee"].ToString());
HotelRequestId = Convert.ToInt32(QuotationRow["HotelRequestId"]);
LstObj.Add(objH);
}
}
}
}
if (objDsQut.Tables[3].Rows.Count > 0)// Hotel Invoice
{
foreach (DataRow QuotationRow in objDsQut.Tables[3].Rows)
{
foreach (GridViewRow row in gvCarBookings.Rows)
{
CheckBox chk = row.FindControl("chkSelect") as CheckBox;
if (chk != null && chk.Checked)
{
ItemInvoiceNo = ItemInvoiceNo + 1;
UKZNInoviceDetails objc = new UKZNInoviceDetails();
objc.accountnumber = "30031";
objc.uniquerequestid = "C_" + QuotationRow["CarDescId"].ToString(); // QuotationRow["Fromcode"].ToString();
objc.invoiceitemdescription = "Car Item Invoice Created for file no" + FileNo;
objc.invoiceitemnumber = ItemInvoiceNo.ToString(); //"A_" + QuotationRow["HotelRequestId"].ToString();
objc.invoiceitemnote = "not paid";
objc.fullyprocessedyn = "N"; //QuotationRow["Fromcode"].ToString();
objc.alreadypaidyn = "N"; // QuotationRow["Fromcode"].ToString();
objc.itemamountincvat = QuotationRow["TotalPrice"].ToString();
objc.commentstmc = "Hotel Invoice Created" + QuotationRow["CarDescId"].ToString();
objc.itemvatamount = _objBoutility.CalculateVat(Convert.ToDecimal(objc.itemamountincvat), _decVarPercentage).ToString();
TotalAmount = TotalAmount + Convert.ToDecimal(QuotationRow["TotalPrice"].ToString());
CabRequestId = Convert.ToInt32(QuotationRow["CarDescId"]);
LstObj.Add(objc);
}
}
}
}
if (TotalAmount > 0)
{
string Invocie = "0";
if (objDsQut.Tables[2].Rows.Count > 0)
{
BALUser objBALUer = new BALUser();
int InvoiceNo = objBALUer.GenerateInvocieNo();
Invocie = "INV" + InvoiceNo.ToString("000");
objTravelRequest.supplierno = _strUKZNsupplierno;
objTravelRequest.invoicenumber = objDsQut.Tables[2].Rows[0]["QuotationRefNo"].ToString().Replace("QT", "IN_"); // Invocie;
objTravelRequest.totamountincvat = TotalAmount.ToString(); // objDsQut.Tables[2].Rows[0]["TripAmount"].ToString();
objTravelRequest.invoicedate = DateTime.Now.ToString("dd-MMM-yyyy").ToUpper();
objTravelRequest.invoicedescription = "Invoice order no " + objDsQut.Tables[2].Rows[0]["ukzn_orderno"].ToString();
objTravelRequest.ordernumber = objDsQut.Tables[2].Rows[0]["ukzn_orderno"].ToString();
objTravelRequest.costcentre = objDsQut.Tables[2].Rows[0]["cost_center"].ToString();
}
objTravelRequest.ListObjectUKZNInvoice = LstObj;
strMessage = _objUKZNTravelRequest.validateinvoice(objTravelRequest);
if (strMessage == "Success")
{
objBALFileManager.UpdateFileMaster(FileNo, Invocie);
lblMsg.Text = _objBoutility.ShowMessage("succcess", "info ", "Invoice created in integrator");
}
else
{
objBALFileManager.UpdateFileMaster(FileNo, strMessage);
lblMsg.Text = _objBoutility.ShowMessage("succcess", "info ", strMessage);
}
}
else
{
lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", "Please select item");
}
}
else
{
lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", "No order find with this order no.");
}
return(strMessage);
}
catch (Exception ex)
{
lblMsg.Text = _objBoutility.ShowMessage("danger", "Error ", ex.Message);
return("");
}
}
