public void BindAgent(Int64 BankId)
{
AgentMaster objAgentMaster = (new Cls_agentmaster_b().SelectById(BankId));
if (objAgentMaster != null)
{
txtAgentName.Text = objAgentMaster.Agentname;
txtAddress.Text = objAgentMaster.Address;
txtMobileNo.Text = objAgentMaster.MobileNo;
txtEmail.Text = objAgentMaster.email;
if (!string.IsNullOrEmpty(objAgentMaster.img))
{
imgCategory.Visible = true;
ViewState["fileName"] = objAgentMaster.img;
imgCategory.ImageUrl = categoryFrontPath + objAgentMaster.img;
btnImageUpload.Visible = false;
btnRemove.Visible = true;
}
else
{
btnImageUpload.Visible = true;
}
}
}
public bool UpdateAgent(AgentMaster a)
{
try
{
a.BookingStatusName = null;
tblAgentMaster agentOld = dbEntity.tblAgentMasters.Where(x => x.AgentID == a.AgentID).FirstOrDefault();
if (agentOld != null)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <AgentMaster, tblAgentMaster>().ForAllMembers(opts => opts.Condition((src, dest, srcMember) => srcMember != null));
});
IMapper mapper = config.CreateMapper();
//mapper.Map(p, projectOld, typeof(Projects), typeof(tblProject));
mapper.Map <AgentMaster, tblAgentMaster>(a, agentOld);
dbEntity.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
log.Error("Error :" + ex);
return(false);
}
}
public bool AddAgent(AgentMaster a)
{
try
{
var checkDuplicateAgentCode = dbEntity.tblAgentMasters.Where(x => x.AgentCode == a.AgentCode).FirstOrDefault();
if (checkDuplicateAgentCode == null)
{
a.BookingStatusName = null;
tblAgentMaster agentNew = new tblAgentMaster();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <AgentMaster, tblAgentMaster>().ForAllMembers(opts => opts.Condition((src, dest, srcMember) => srcMember != null));
});
IMapper mapper = config.CreateMapper();
//mapper.Map(p, projectOld, typeof(Projects), typeof(tblProject));
mapper.Map <AgentMaster, tblAgentMaster>(a, agentNew);
dbEntity.tblAgentMasters.Add(agentNew);
dbEntity.SaveChanges();
var agentID = dbEntity.tblAgentMasters.Where(x => x.AgenteMail == a.AgenteMail).Select(x => x.AgentID).FirstOrDefault();
var Projects = dbEntity.tblProjects.Where(x => x.BookingStatus == "O").ToList();
foreach (var project in Projects)
{
tblAgentProjectLevel agentProjectLevel = new tblAgentProjectLevel();
agentProjectLevel.AgentID = agentID;
agentProjectLevel.ProjectID = project.ProjectID;
agentProjectLevel.LevelID = 27;
agentProjectLevel.Status = "I";
agentProjectLevel.CreatedBy = a.CreatedBy;
agentProjectLevel.CreatedDate = a.CreatedDate;
dbEntity.tblAgentProjectLevels.Add(agentProjectLevel);
}
//tblAgentTotalPayment
dbEntity.SaveChanges();
a.isDuplicateAgentCode = false;
return(true);
}
else
{
a.isDuplicateAgentCode = true;
return(false);
}
}
catch (Exception ex)
{
log.Error("Error :" + ex);
return(false);
}
}
public AgentMaster SelectById(Int64 bankid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
AgentMaster objAgentMaster = new AgentMaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "agentmaster_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@aid", bankid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objAgentMaster.aid = Convert.ToInt32(ds.Tables[0].Rows[0]["aid"]);
objAgentMaster.Agentname = Convert.ToString(ds.Tables[0].Rows[0]["Agentname"]);
objAgentMaster.Address = Convert.ToString(ds.Tables[0].Rows[0]["Address"]);
objAgentMaster.MobileNo = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo"]);
objAgentMaster.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]);
objAgentMaster.createddate = Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]);
objAgentMaster.img = Convert.ToString(ds.Tables[0].Rows[0]["img"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objAgentMaster);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
AgentMaster objAgentMaster = new AgentMaster();
objAgentMaster.Agentname = txtAgentName.Text.Trim();
objAgentMaster.Address = txtAddress.Text.Trim();
objAgentMaster.MobileNo = txtMobileNo.Text.Trim();
objAgentMaster.email = txtEmail.Text.Trim();
if (ViewState["fileName"] != null)
{
objAgentMaster.img = ViewState["fileName"].ToString();
}
if (Request.QueryString["id"] != null)
{
objAgentMaster.aid = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_agentmaster_b().Update(objAgentMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageAgent.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Agent Not Updated";
BindAgent(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_agentmaster_b().Insert(objAgentMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageAgent.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Agent Not Inserted";
}
}
}
// Url:localhost:5024/api/Values/GetCruiseOpendates?AgentId=248
public DataTable GetCruiseOpendates(int AgentId)
{
DataTable dt12 = new DataTable();
HttpContext httpContext = HttpContext.Current;
string authHeader = httpContext.Request.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Basic"))
{
string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim();
blsrch.action = "GetOpenDatesCruiseApi";
blsrch.StartDate = System.DateTime.Now;
blsrch.EndDate = Convert.ToDateTime("1900-01-01");
blsrch.AgentId = AgentId;
//{
// //blsrch.AgentId = 247;
//}
AgentMaster oAgentMaster = new AgentMaster();
// int AgentId = blsrch.AgentId;
AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId);
string TokenNo = oAgentData[0].TokenNo.ToString();
if (TokenNo != "" && TokenNo == encodedUsernamePassword)
{
dtres = dlsrch.GetCruiseOpenDatesPackage(blsrch);
DataTable dt = dlsrch.fetchall();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
blsrch.PackageId = dt.Rows[i]["PackageId"].ToString();
dtres = dlsrch.GetCruiseOpenDatesPackage(blsrch);
dt12.Merge(dtres);
dt12.AcceptChanges();
}
}
DataSet ds = new DataSet();
ds.Tables.Add(dt12);
string value = ds.GetXml();
}
return(dt12);
}
else
{
return(dt12);
}
}
//
// POST: /Agent/Delete/5
public ActionResult DeleteConfirmed(int id)
{
AgentMaster agentMaster = db.AgentMasters.Find(id);
UserRegistration a = (from c in db.UserRegistrations where c.UserID == agentMaster.UserID select c).FirstOrDefault();
db.AgentMasters.Remove(agentMaster);
db.SaveChanges();
if (a != null)
{
db.UserRegistrations.Remove(a);
}
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully Deleted Agent.";
return(RedirectToAction("Index"));
}
private void FillAgents()
{
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetData();
ListItemCollection li = new ListItemCollection();
ListItem l = new ListItem("Choose Agent", "0");
ddlAgent.Items.Insert(0, l);
if (oAgentData != null)
{
for (int i = 0; i < oAgentData.Length; i++)
{
l = new ListItem(oAgentData[i].AgentName.ToString(), oAgentData[i].AgentId.ToString());
ddlAgent.Items.Insert(i + 1, l);
}
}
}
// GET api/<controller>
//public IEnumerable<Student> Get()
//{
// return stud;
//}
// GET api/<controller>/5
//localhost:5024/api/Values/7 night 8 day MV Mahabaahu Upstream Cruise/2018-01-14/248
public string Get(string pakackagename, DateTime departure, int AgentId)
{
string value = "";
HttpContext httpContext = HttpContext.Current;
string authHeader = httpContext.Request.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Basic"))
{
string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim();
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId);
string TokenNo = oAgentData[0].TokenNo.ToString();
if (TokenNo != "" && TokenNo == encodedUsernamePassword)
{
var dateAndTime = DateTime.Now;
var date = dateAndTime.Date;
//DateTime d = DateTime.Now.Year;
DataTable dt1 = dlsr.getpackaageid(pakackagename, departure);
if (dt1 != null && dt1.Rows.Count > 0)
{
pakackageid = dt1.Rows[0]["PackageId"].ToString();
departureId = Convert.ToInt32(dt1.Rows[0]["Id"].ToString());
}
DataTable dt = cab.bindroomddl(pakackageid, departureId);
dv = new DataView();
dv = new DataView(dt, "BookedStatus='" + "Available" + "'", "BookedStatus", DataViewRowState.CurrentRows);
DataTable dt2 = dv.ToTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt2);
value = ds.GetXml();
return(value);
}
else
{
return(value);
}
}
else
{
return(value);
}
}
public Int64 Insert(AgentMaster objAgentMaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "agentmaster_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@aid";
param.Value = objAgentMaster.aid;
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Agentname", objAgentMaster.Agentname);
cmd.Parameters.AddWithValue("@Address", objAgentMaster.Address);
cmd.Parameters.AddWithValue("@MobileNo", objAgentMaster.MobileNo);
cmd.Parameters.AddWithValue("@email", objAgentMaster.email);
cmd.Parameters.AddWithValue("@img", objAgentMaster.img);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
//localhost:5024/api/Values/203,109,108/7/2/248 call MultiplelockRoom
public string GetLockRoom(string roomno, int accomid, int roomcatid, int AgentId)
{
string value = "";
HttpContext httpContext = HttpContext.Current;
string authHeader = httpContext.Request.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Basic"))
{
string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim();
//var values = Request.GetQueryNameValuePairs()
// .Where(kvp => kvp.Key == "roomno")
// .Select(kvp => int.Parse(kvp.Value))
// .ToArray();
AgentMaster oAgentMaster = new AgentMaster();
// int AgentId = blsrch.AgentId;
AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId);
string TokenNo = oAgentData[0].TokenNo.ToString();
if (TokenNo != "" && TokenNo == encodedUsernamePassword)
{
string[] values = roomno.Split(',');
foreach (var lockRoom in values)
{
roomno = lockRoom.ToString();
cab.LockTheBooking(roomno, accomid, roomcatid);
}
value = "Room is Locked";
return(value);
}
return(value);
}
else
{
value = "Please set Header Authentication";
return(value);
}
}
private void FillRefAgents()
{
try
{
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetRefAgentData();
ListItemCollection li = new ListItemCollection();
ListItem l = new ListItem("Choose Ref Agent", "0");
ddlRefAgent.Items.Insert(0, l);
if (oAgentData != null)
{
for (int i = 0; i < oAgentData.Length; i++)
{
l = new ListItem(oAgentData[i].AgentName.ToString(), oAgentData[i].AgentId.ToString());
ddlRefAgent.Items.Insert(i + 1, l);
string Email = oAgentData[i].EmailId.ToString();
//Session["Email"] = Email;
}
}
}
catch { }
}
protected void btnGenarateToken_Click(object sender, EventArgs e)
{
lblError.Text = "";
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetData(Convert.ToInt32(ddlAgent.SelectedValue));
string AgentCode = oAgentData[0].AgentCode.ToString();
string AgentPassword = oAgentData[0].Password.ToString();
if (AgentCode != "" && AgentPassword != "")
{
string Token = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(AgentCode + ":" + AgentPassword));
// byte[] byt = Encoding.ASCII.GetBytes(Token);
// byte[] data1 = Convert.FromBase64String(Token);
//string value = Encoding.ASCII.GetString(byt);
AgentDTO oAgentSaveData = new AgentDTO();
oAgentSaveData.AgentId = Convert.ToInt32(ddlAgent.SelectedValue);
oAgentSaveData.TokenNo = Token;
bool Agent = oAgentMaster.ApiAuthInsert(oAgentSaveData);
if (Agent)
{
lblError.Text = "Token Genarate Successfully";
}
else
{
lblError.Text = "This Agent Is Already Genarate Token";
}
}
else
{
lblError.Text = "This Agent Can't Genarate Token,Password or AgentCode Missing";
}
BindGrid();
}
public void SetResource(AgentMaster.EResource its_resource)
{
TheSelf.TheResource = its_resource;
SetTileRenderer();
}
///api/Values/5 nights 6 days MV Mahabaahu Upstream Cruise/2018-10-16/2018-10-21/4/rabiul/102,208/7/2/online/248
public string Get1(string pakackagename, DateTime chekindate, DateTime checkoutdate, int total, string refrence, string roomno, int accomid, int roomcatid, string paymentmethod, int agentid)
{
string value = "";
DataSet ds = new DataSet();
HttpContext httpContext = HttpContext.Current;
string authHeader = httpContext.Request.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Basic"))
{
string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim();
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(agentid);
string TokenNo = oAgentData[0].TokenNo.ToString();
if (TokenNo != "" && TokenNo == encodedUsernamePassword)
{
DataTable dt1 = dlsr.getpackaageid(pakackagename, chekindate);
if (dt1 != null && dt1.Rows.Count > 0)
{
pakackageid = dt1.Rows[0]["PackageId"].ToString();
departureId = Convert.ToInt32(dt1.Rows[0]["Id"].ToString());
}
DataTable dt = cab.bindroomddl(pakackageid, departureId);
dv = new DataView();
string[] strArray = roomno.Split(',');
//foreach (object obj in strArray)
//{
// roomno = obj.ToString();
//}
//var values = Request.GetQueryNameValuePairs()
// .Where(kvp => kvp.Key == "roomno")
// .Select(kvp => int.Parse(kvp.Value))
// .ToArray();
int n = cab.InsertParentTableData(pakackageid, chekindate, checkoutdate, total, refrence, agentid);
foreach (var lockRoom in strArray)
{
roomno = lockRoom.ToString();
dv = new DataView(dt, "RoomNo='" + roomno + "'", "RoomNo", DataViewRowState.CurrentRows);
DataTable dtcheck = dv.ToTable();
dv = new DataView(dtcheck, "BookedStatus='" + "Available" + "'", "BookedStatus", DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
//var values = Request.GetQueryNameValuePairs()
// .Where(kvp => kvp.Key == "roomno")
// .Select(kvp => int.Parse(kvp.Value))
// .ToArray();
//foreach (var lockRoom in strArray)
//{
//roomno = lockRoom.ToString();
cab.InsertChildTableData(n, total, roomno, paymentmethod, chekindate, pakackageid, total, roomcatid);
cab.LockTheBooking(roomno, accomid, roomcatid);
blsr.action = "fetchbybookingId";
blsr._iBookingId = n;
DataTable dtfetch = dlsr.fetchbybookingid(blsr);
DataTable dtvalue = cab.loadbookingDetails(pakackagename, n, total, roomno, paymentmethod, chekindate, checkoutdate, pakackageid, total, roomcatid, Convert.ToInt32(dtfetch.Rows[0]["NoOFNights"].ToString()));
//DataSet ds = new DataSet();
ds.Tables.Add(dtvalue);
//value = ds.GetXml();
//// }
//return value;
}
//else
//{
// return "Room is already booked";
//}
}
}
value = ds.GetXml();
// }
if (value != "<NewDataSet />")
{
return(value);
}
else
{
return("Room is already booked");
}
}
else
{
return(value);
}
}
public void SetBuilding(AgentMaster.EBuilding its_building)
{
TheSelf.TheType = its_building;
SetTileRenderer();
}
public ActionResult Create(AgentVM item)
{
int companyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
int BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int? max = (from c in db.AgentMasters orderby c.AgentID descending select c.AgentID).FirstOrDefault();
AgentMaster a = new AgentMaster();
PickupRequestDAO _dao = new PickupRequestDAO();
int roleid = db.RoleMasters.Where(t => t.RoleName == "Agent").FirstOrDefault().RoleID;
UserRegistration u = new UserRegistration();
UserRegistration x = (from b in db.UserRegistrations where b.UserName == item.Email select b).FirstOrDefault();
if (x == null)
{
int max1 = (from c1 in db.UserRegistrations orderby c1.UserID descending select c1.UserID).FirstOrDefault();
u.UserID = max1 + 1;
u.UserName = item.Email;
u.EmailId = item.Email;
if (item.Password == null)
{
u.Password = _dao.RandomPassword(6);
}
else
{
u.Password = item.Password;
}
u.Phone = item.Phone;
u.IsActive = true;
u.RoleID = roleid;
db.UserRegistrations.Add(u);
db.SaveChanges();
}
if (max == null || max == 0)
{
a.AgentID = 1;
a.Name = item.AgentName;
a.AgentCode = item.AgentCode;
a.Address1 = item.Address1;
a.Address2 = item.Address2;
a.Address3 = item.Address3;
a.Phone = item.Phone;
a.Fax = item.Fax;
a.WebSite = item.WebSite;
a.ContactPerson = item.ContactPerson;
a.AcCompanyID = companyId;
//a.CountryID = item.CountryID;
//a.CityID = item.CityID;
//a.LocationID = item.LocationID;
a.CurrencyID = item.CurrencyID;
a.ZoneCategoryID = item.ZoneCategoryID;
a.AcHeadID = item.AcHeadID;
a.CreditLimit = item.CreditLimit;
a.CountryName = item.CountryName;
a.CityName = item.CityName;
a.LocationName = item.LocationName;
a.Email = item.Email;
a.Password = "";
a.AgentType = item.AgentType;
a.UserID = u.UserID;
if (item.StatusActive == null)
{
a.StatusActive = false;
}
else
{
a.StatusActive = Convert.ToBoolean(item.StatusActive);
}
a.BranchID = BranchID;
}
else
{
a.AgentID = Convert.ToInt32(max) + 1;
a.Name = item.AgentName;
a.AgentCode = item.AgentCode;
a.Address1 = item.Address1;
a.Address2 = item.Address2;
a.Address3 = item.Address3;
a.Phone = item.Phone;
a.Fax = item.Fax;
a.WebSite = item.WebSite;
a.ContactPerson = item.ContactPerson;
a.AcCompanyID = companyId;
a.CountryName = item.CountryName;
a.CityName = item.CityName;
a.LocationName = item.LocationName;
a.CurrencyID = item.CurrencyID;
a.ZoneCategoryID = item.ZoneCategoryID;
a.AcHeadID = item.AcHeadID;
a.CreditLimit = item.CreditLimit;
a.Email = item.Email;
a.Password = "";
a.AgentType = item.AgentType;
a.UserID = u.UserID;
a.BranchID = BranchID;
if (item.StatusActive == null)
{
a.StatusActive = false;
}
else
{
a.StatusActive = Convert.ToBoolean(item.StatusActive);
}
}
try
{
db.AgentMasters.Add(a);
db.SaveChanges();
if (item.EmailNotify == true)
{
EmailDAO _emaildao = new EmailDAO();
_emaildao.SendCustomerEmail(item.Email, item.Email, u.Password);
}
TempData["SuccessMsg"] = "You have successfully added Agent.";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.currency = db.CurrencyMasters.ToList();
ViewBag.zonecategory = db.ZoneCategories.ToList();
ViewBag.achead = db.AcHeads.ToList();
ViewBag.roles = db.RoleMasters.ToList();
TempData["WarningMsg"] = ex.Message;
return(View(item));
}
}
public ActionResult Edit(AgentVM item)
{
UserRegistration u = new UserRegistration();
PickupRequestDAO _dao = new PickupRequestDAO();
int BranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int accompanyid = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
AgentMaster a = db.AgentMasters.Find(item.ID);
a.AcCompanyID = accompanyid;
a.Name = item.AgentName;
a.AgentCode = item.AgentCode;
a.Address1 = item.Address1;
a.Address2 = item.Address2;
a.Address3 = item.Address3;
a.Phone = item.Phone;
a.Fax = item.Fax;
a.WebSite = item.WebSite;
a.ContactPerson = item.ContactPerson;
a.CountryName = item.CountryName;
a.CityName = item.CityName;
a.LocationName = item.LocationName;
a.CurrencyID = item.CurrencyID;
// a.ZoneCategoryID = item.ZoneCategoryID;
//a.AcHeadID = item.AcHeadID;
a.CreditLimit = item.CreditLimit;
a.AgentType = item.AgentType;
if (item.StatusActive != null)
{
a.StatusActive = Convert.ToBoolean(item.StatusActive);
}
if (a.BranchID == null)
{
a.BranchID = BranchID;
}
UserRegistration x = null;
if (a.UserID != null && a.UserID > 0)
{
x = (from b in db.UserRegistrations where b.UserID == a.UserID select b).FirstOrDefault();
}
if (a.Email != item.Email || x == null)
{
if (x == null)
{
int max1 = (from c1 in db.UserRegistrations orderby c1.UserID descending select c1.UserID).FirstOrDefault();
int roleid = db.RoleMasters.Where(t => t.RoleName == "Agent").FirstOrDefault().RoleID;
u.UserID = max1 + 1;
u.UserName = item.Email;
u.EmailId = item.Email;
if (item.Password == "" || item.Password == null)
{
u.Password = _dao.RandomPassword(6);
}
else
{
u.Password = item.Password;
}
u.Phone = item.Phone;
u.IsActive = true;
u.RoleID = roleid;
db.UserRegistrations.Add(u);
db.SaveChanges();
a.Email = item.Email;
a.UserID = u.UserID;
}
else
{
//checking duplicate
UserRegistration x1 = (from b in db.UserRegistrations where b.UserName == item.Email && b.UserID != a.UserID select b).FirstOrDefault();
if (x1 == null)
{
x.EmailId = item.Email;
if (item.Password == "")
{
x.Password = _dao.RandomPassword(6);
}
else
{
x.Password = item.Password;
}
db.Entry(x).State = EntityState.Modified;
db.SaveChanges();
}
a.Email = item.Email;
a.UserID = x.UserID;
}
}
else
{
if (a.UserID == null || a.UserID == 0)
{
int max1 = (from c1 in db.UserRegistrations orderby c1.UserID descending select c1.UserID).FirstOrDefault();
int roleid = db.RoleMasters.Where(t => t.RoleName == "Agent").FirstOrDefault().RoleID;
u.UserID = max1 + 1;
u.UserName = item.Email;
u.EmailId = item.Email;
if (item.Password == "")
{
u.Password = _dao.RandomPassword(6);
}
else
{
u.Password = item.Password;
}
u.Phone = item.Phone;
u.IsActive = true;
u.RoleID = roleid;
db.UserRegistrations.Add(u);
db.SaveChanges();
a.UserID = u.UserID;
}
else
{
u = (from b in db.UserRegistrations where b.UserID == a.UserID select b).FirstOrDefault();
if (item.Password != u.Password)
{
u.Password = item.Password;
}
db.Entry(u).State = EntityState.Modified;
db.SaveChanges();
}
}
if (ModelState.IsValid)
{
db.Entry(a).State = EntityState.Modified;
db.SaveChanges();
if (item.EmailNotify == true)
{
EmailDAO _emaildao = new EmailDAO();
_emaildao.SendCustomerEmail(item.Email, item.Email, u.Password);
}
TempData["SuccessMsg"] = "You have successfully Updated Agent.";
return(RedirectToAction("Index"));
}
return(View());
}
public RootObject MappingAgentDatatoServiceData(ref Models.AgentonBoarding.RecruitmentAgent objRecruitmentAgent)
{
RootObject objRootObject = new RootObject();
objRootObject.agentMaster = new List <AgentMaster>();
objRootObject.agentAddressDet = new List <AgentAddressDet>();
objRootObject.settlementMaster = new List <SettlementMaster>();
AgentMaster objAgentMaster = new AgentMaster();
AgentAddressDet objAgentAddressDet = new AgentAddressDet();
SettlementMaster objSettlementMaster = new SettlementMaster();
objAgentMaster.agentCode = objRecruitmentAgent.AgentCode;
objAgentMaster.companyCode = "00003";
objAgentMaster.agentName = objRecruitmentAgent.FirstName;
objAgentMaster.appointmentDate = objRecruitmentAgent.AppointedDate;
objAgentMaster.authorizedDate = Convert.ToString(objRecruitmentAgent.ApplicationDate);
objAgentMaster.branchCode = objRecruitmentAgent.BranchCode;
// objAgentMaster.createBy = objRecruitmentAgent.CreatedBy;
objAgentMaster.createBy = "venkat";
var create = DateTime.Now;
objAgentMaster.createDt = create.Day + "-" + create.Month + "-" + create.Year;;
objAgentMaster.dateOfBirth = Convert.ToString(objRecruitmentAgent.DOB);
objAgentMaster.districtCode = objRecruitmentAgent.objCommunicationAddress.DistrictCode;
objAgentMaster.districtName = objRecruitmentAgent.objCommunicationAddress.District;
objAgentMaster.epfNo = Convert.ToString(objRecruitmentAgent.EPFNo);
objAgentMaster.epfNoActual = Convert.ToString(objRecruitmentAgent.EPFNo);
//objAgentMaster.fax=objRecruitmentAgent
objAgentMaster.firstName = objRecruitmentAgent.FirstName;
objAgentMaster.lastName = objRecruitmentAgent.LastName;
objAgentMaster.maritalStatus = objRecruitmentAgent.MaritalStatus;
objAgentMaster.middleName = objRecruitmentAgent.MiddleName;
// objAgentMaster.modifyBy = objRecruitmentAgent.CreatedBy;
objAgentMaster.modifyBy = "venkat";
var modifyDate = DateTime.Now;
objAgentMaster.modifyDt = modifyDate.Day + "-" + modifyDate.Month + "-" + modifyDate.Year;
objAgentMaster.nationality = objRecruitmentAgent.Nationality;
objAgentMaster.nicNumber = objRecruitmentAgent.NICNO;
objAgentAddressDet.pinCode = objRecruitmentAgent.objCommunicationAddress.Pincode;
objAgentMaster.printName = objRecruitmentAgent.PrintName;
objAgentMaster.provinceCode = Convert.ToString(objRecruitmentAgent.objCommunicationAddress.StateID);
objAgentMaster.provinceName = objRecruitmentAgent.objCommunicationAddress.State;
objAgentMaster.remarks = objRecruitmentAgent.InterviewDetailsNotes;
objAgentMaster.sex = objRecruitmentAgent.Gender;
objAgentMaster.sliiRegno = objRecruitmentAgent.SLIIRegNo;
objAgentMaster.authorizedUser = objRecruitmentAgent.InterviewCode;
objAgentMaster.agentCategory = objRecruitmentAgent.SpecifyProfession;
objAgentMaster.masterAgent = objRecruitmentAgent.AgentCode;
objAgentMaster.geographicalClassification = objRecruitmentAgent.Nationality;
objAgentMaster.status = objRecruitmentAgent.Status;
objAgentMaster.agentClass = objRecruitmentAgent.Designation;
objAgentMaster.agentNature = "I";
objAgentMaster.insuranceType = "LIFE";
objAgentMaster.shortName = objRecruitmentAgent.FirstName;
objAgentMaster.natureType = "S";
objRootObject.agentMaster.Add(objAgentMaster);
objAgentAddressDet.address1 = objRecruitmentAgent.objCommunicationAddress.Address1;
objAgentAddressDet.address2 = objRecruitmentAgent.objCommunicationAddress.Address2;
objAgentAddressDet.cityCode = objRecruitmentAgent.objCommunicationAddress.CityCode;
objAgentAddressDet.cityName = objRecruitmentAgent.objCommunicationAddress.City;
objAgentAddressDet.countryName = objRecruitmentAgent.Nationality;
objAgentAddressDet.emailAddressLife = objRecruitmentAgent.EmailID;
objAgentAddressDet.telephone = Convert.ToString(objRecruitmentAgent.OfficePhNo);
objAgentAddressDet.telephoneMobile = Convert.ToString(objRecruitmentAgent.MobileNo);
objAgentAddressDet.telephoneMobileSecond = Convert.ToString(objRecruitmentAgent.AltMobileNo);
objAgentAddressDet.telephoneResidence = Convert.ToString(objRecruitmentAgent.ResidencePhNo);
objAgentAddressDet.addressType = "BLADR";
objAgentAddressDet.serialNo = "1";
// objRootObject.userId = objRecruitmentAgent.CreatedBy;
objRootObject.userId = "venkat";
objRootObject.agentAddressDet.Add(objAgentAddressDet);
objSettlementMaster.contactInfo = Convert.ToString(objRecruitmentAgent.MobileNo);
objSettlementMaster.settlementInstitution = objRecruitmentAgent.BankBranchCode;
objSettlementMaster.settlementAccount = objRecruitmentAgent.AccountNo;
objSettlementMaster.settlementBranch = objRecruitmentAgent.BranchCode;
objSettlementMaster.settlementType = objRecruitmentAgent.PaymentMode;
objRootObject.settlementMaster.Add(objSettlementMaster);
return(objRootObject);
}
[UsedImplicitly] private void Awake()
{
self = this;
my_active_agents = new List<Agent>();
my_running_agent_batches = new List<List<Agent>>();
my_agent_types = new Dictionary<string, Agent>();
/*serialised_person_names = new List<string>();
serialised_person_jobs = new List<EJob>();
serialised_person_locations = new List<string>();
serialised_building_names = new List<string>();
serialised_building_types = new List<EBuilding>();
serialised_building_resources = new List<EResource>();
my_person_incriment = 0;
my_building_incriment = 0;*/
}
