public async Task <IHttpActionResult> PutAGENT(string id, AGENT aGENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != aGENT.AgentCode)
{
return(BadRequest());
}
db.Entry(aGENT).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AGENTExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void gvUSERINFO_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblAgent_LocationID = (Label)e.Row.FindControl("lblAgent_LocationID");
Label lblAgent_LocationName = (Label)e.Row.FindControl("lblAgent_LocationName");
if (ddlUserType.SelectedItem.Value.ToString() == "Agent")
{
AGENT aGENT = new AGENT();
aGENT = AGENTManager.GetAGENTByID(int.Parse(lblAgent_LocationID.Text));
if (aGENT != null)
{
lblAgent_LocationName.Text = aGENT.AGENTNAME.ToString();
}
}
else
{
LOCATION lOCATION = new LOCATION();
lOCATION = LOCATIONManager.GetLOCATIONByID(int.Parse(lblAgent_LocationID.Text));
if (lOCATION != null)
{
lblAgent_LocationName.Text = lOCATION.BRANCH.ToString();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!User.Identity.IsAuthenticated)
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
else
{
reLoadSession();
}
AGENT aGENT = (AGENT)Session["aGENT"];
hfAgentID.Value = aGENT.AGENTID.ToString();
if (Request.QueryString["Daily"] != null)
{
trFromDate.Visible = false;
trToDate.Visible = false;
}
txtFromDate.Text = DateTime.Today.ToShortDateString();
txtToDate.Text = DateTime.Today.ToShortDateString();
tblTotal.Visible = false;
loadLocation();
}
}
public bool UpdateAGENT(AGENT aGENT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateAGENT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AGENTID", SqlDbType.Int).Value = aGENT.AGENTID;
cmd.Parameters.Add("@AGENTNAME", SqlDbType.VarChar).Value = aGENT.AGENTNAME;
cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar).Value = aGENT.USERNAME;
cmd.Parameters.Add("@AGENTLOCATION", SqlDbType.VarChar).Value = aGENT.AGENTLOCATION;
cmd.Parameters.Add("@AGENTADDRESS", SqlDbType.VarChar).Value = aGENT.AGENTADDRESS;
cmd.Parameters.Add("@AGENTCITY", SqlDbType.VarChar).Value = aGENT.AGENTCITY;
cmd.Parameters.Add("@AGENTSTATE", SqlDbType.VarChar).Value = aGENT.AGENTSTATE;
cmd.Parameters.Add("@AGENTZIP", SqlDbType.VarChar).Value = aGENT.AGENTZIP;
cmd.Parameters.Add("@AGENTPHONE", SqlDbType.VarChar).Value = aGENT.AGENTPHONE;
cmd.Parameters.Add("@AGENTACC", SqlDbType.VarChar).Value = aGENT.AGENTACC;
cmd.Parameters.Add("@CREATEDBY", SqlDbType.Int).Value = aGENT.CREATEDBY;
cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = aGENT.CREATEDON;
cmd.Parameters.Add("@UPDATEDBY", SqlDbType.Int).Value = aGENT.UPDATEDBY;
cmd.Parameters.Add("@UPDATEDON", SqlDbType.DateTime).Value = aGENT.UPDATEDON;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
private void InsertAgentInfo()
{
try
{
AGENT aGENT = new AGENT();
aGENT.AGENTNAME = txtAGENTNAME.Text;
aGENT.USERNAME = txtUserName.Text;
aGENT.AGENTLOCATION = txtAGENTLOCATION.Text;
aGENT.AGENTADDRESS = txtAGENTADDRESS.Text;
aGENT.AGENTCITY = txtAGENTCITY.Text;
aGENT.AGENTSTATE = txtAGENTSTATE.Text;
aGENT.AGENTZIP = txtAGENTZIP.Text;
aGENT.AGENTPHONE = txtAGENTPHONE.Text;
aGENT.AGENTACC = txtAGENTACC.Text;
aGENT.CREATEDBY = 1;
aGENT.CREATEDON = DateTime.Now;
aGENT.UPDATEDBY = 1;
aGENT.UPDATEDON = DateTime.Now;
int resutl = AGENTManager.InsertAGENT(aGENT);
if (resutl > 0)
{
lblregistrationError.Text = "Successfully Submitted!";
ClearData();
}
}
catch (Exception ex)
{
lblregistrationError.Text = ex.Message;
}
}
public ActionResult Edit()
{
var model = Session[CommonConstants.USER_SESSION]; //khai báo 1 session bên common giống như bên Cart
var temp = new USER_INFORMATION();
if (model != null)
{
temp = (USER_INFORMATION)model;
}
HttpClient client = new AccessAPI().Access();
var user = (USER_INFORMATION)Session[CommonConstants.USER_SESSION];
var pass = Session[CommonConstants.HASH_PASSWORD];
StringContent content = new StringContent("username="******"&password="******"&grant_type=password");
HttpResponseMessage res = client.PostAsync(string.Format("api/security/token"), content).Result;
TokenModel token = res.Content.ReadAsAsync <TokenModel>().Result;
client.DefaultRequestHeaders.TryAddWithoutValidation("Authorization", "Bearer " + token.access_token);
HttpResponseMessage response = client.GetAsync(string.Format("api/AGENT/FindAgent?agentCode={0}", temp.UserName)).Result;
var agent = new AGENT();
if (response.IsSuccessStatusCode)
{
agent = response.Content.ReadAsAsync <AGENT>().Result;
//return RedirectToAction("Index", "Home");
}
return(View(agent));
}
public AGENT GetAGENTFromReader(IDataReader reader)
{
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
try
{
AGENT aGENT = new AGENT
(
reader["AGENTID"] != DBNull.Value? (int)reader["AGENTID"]:0,
reader["AGENTNAME"] != DBNull.Value? reader["AGENTNAME"].ToString(): "",
reader["USERNAME"] != DBNull.Value? reader["USERNAME"].ToString(): "",
reader["AGENTLOCATION"] != DBNull.Value? reader["AGENTLOCATION"].ToString(): "",
reader["AGENTADDRESS"] != DBNull.Value? reader["AGENTADDRESS"].ToString(): "",
reader["AGENTCITY"] != DBNull.Value? reader["AGENTCITY"].ToString(): "",
reader["AGENTSTATE"] != DBNull.Value? reader["AGENTSTATE"].ToString(): "",
reader["AGENTZIP"] != DBNull.Value? reader["AGENTZIP"].ToString(): "",
reader["AGENTPHONE"] != DBNull.Value? reader["AGENTPHONE"].ToString(): "",
reader["AGENTACC"] != DBNull.Value? reader["AGENTACC"].ToString(): "",
reader["CREATEDBY"] != DBNull.Value? (int)reader["CREATEDBY"]:0,
reader["CREATEDON"] != DBNull.Value? (DateTime)reader["CREATEDON"]: nullDate,
reader["UPDATEDBY"] != DBNull.Value? (int)reader["UPDATEDBY"]:0,
reader["UPDATEDON"] != DBNull.Value? (DateTime)reader["UPDATEDON"]: nullDate
);
return(aGENT);
}
catch (Exception ex)
{
return(null);
}
}
public async Task <IHttpActionResult> PostAGENT(AGENT aGENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.AGENT.Add(aGENT);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (AGENTExists(aGENT.AgentCode))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = aGENT.AgentCode }, aGENT));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!User.Identity.IsAuthenticated)
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
else
{
reLoadSession();
if (Session["snreceiverID"] != null && Session["snreceiverID"] != null)
{
AGENT aGENT = (AGENT)Session["aGENT"];
hfAgentID.Value = aGENT.AGENTID.ToString();
LoadBranch(aGENT.AGENTID);
LoadCountry(aGENT.AGENTID);
}
else
{
Response.Redirect("SearchReceiverPage.aspx");
}
}
}
}
private void UpdateUserInfo()
{
AGENT aGENT = new AGENT();
aGENT = AGENTManager.GetAGENTByID(Int32.Parse(lblUserInfoID.Text));
AGENT tempAGENT = new AGENT();
tempAGENT.AGENTID = aGENT.AGENTID;
tempAGENT.AGENTNAME = txtAGENTNAME.Text;
tempAGENT.USERNAME = txtUserName.Text;
tempAGENT.AGENTLOCATION = txtAGENTLOCATION.Text;
tempAGENT.AGENTADDRESS = txtAGENTADDRESS.Text;
tempAGENT.AGENTCITY = txtAGENTCITY.Text;
tempAGENT.AGENTSTATE = txtAGENTSTATE.Text;
tempAGENT.AGENTZIP = txtAGENTZIP.Text;
tempAGENT.AGENTPHONE = txtAGENTPHONE.Text;
tempAGENT.AGENTACC = txtAGENTACC.Text;
tempAGENT.CREATEDBY = 1;
tempAGENT.CREATEDON = aGENT.CREATEDON;
tempAGENT.UPDATEDBY = 1;
tempAGENT.UPDATEDON = DateTime.Now;
bool result = AGENTManager.UpdateAGENT(tempAGENT);
ClearData();
showUserInfoGrid();
}
public ActionResult DeleteConfirmed(int id)
{
AGENT aGENT = db.AGENT.Find(id);
db.AGENT.Remove(aGENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static AGENT GetAGENTByUserName(string userName)
{
AGENT aGENT = new AGENT();
SqlAGENTProvider sqlAGENTProvider = new SqlAGENTProvider();
aGENT = sqlAGENTProvider.GetAGENTByUserName(userName);
return(aGENT);
}
public static AGENT GetAGENTByID(int id)
{
AGENT aGENT = new AGENT();
SqlAGENTProvider sqlAGENTProvider = new SqlAGENTProvider();
aGENT = sqlAGENTProvider.GetAGENTByID(id);
return(aGENT);
}
private void loadLocation()
{
List <LOCATION> locations = new List <LOCATION>();
if (Session["userType"] != null && (Session["lOCATION"] != null || Session["aGENT"] != null))
{
if (Session["userType"].ToString() == "Location")
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = (LOCATIONGROUP)Session["lOCATION"];
hfLoggedinLocationID.Value = lOCATIONGROUP.LOCATIONGROUPID.ToString();
if (ddlAgent.SelectedItem.Text != "All Agents")
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentIDnGroupID(int.Parse(ddlAgent.SelectedItem.Value), int.Parse(hfLoggedinLocationID.Value));
}
else
{
locations = LOCATIONManager.GetAllLOCATIONsByGroupID(int.Parse(hfLoggedinLocationID.Value));
}
//locations = LOCATIONManager.GetAllLOCATIONsByGroupID(int.Parse(hfLoggedinLocationID.Value));
//trLocation.Visible = false;
}
else if (Session["userType"].ToString() == "Agent")
{
AGENT aGENT = (AGENT)Session["aGENT"];
hfAgentID.Value = aGENT.AGENTID.ToString();
trLocation.Visible = true;
if (hfAgentID.Value == "4")
{
if (ddlAgent.SelectedItem.Text != "All Agents")
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentID(int.Parse(ddlAgent.SelectedItem.Value));
}
else
{
locations = LOCATIONManager.GetAllLOCATIONs();
}
}
else
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentID(int.Parse(hfAgentID.Value));
}
}
dlLocation.DataSource = locations;
dlLocation.DataBind();
tblSearchByRefCode.Visible = false;
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
public async Task <INode> CreateNode <AGENT>() where AGENT : IAgent
{
long identity = IdGenerator.NewIdentity();
AGENT agent = GrainFactory.GetGrain <AGENT>(identity);
await agent.Online();
return(GrainFactory.GetGrain <INode>(identity));
}
public AGENT FindAgent(string agentCode)
{
object[] paremeter =
{
new SqlParameter("@AgentCode", agentCode)
};
AGENT res = db.Database.SqlQuery <AGENT>("sp_GetAgent @AgentCode", paremeter).FirstOrDefault();
return(res);
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,AdresseID")] AGENT aGENT)
{
if (ModelState.IsValid)
{
db.Entry(aGENT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdresseID = new SelectList(db.ADRESS, "Id", "Street", aGENT.AdresseID);
return(View(aGENT));
}
public dynamic Test(int ID)
{
bool error = false;
db.Configuration.ProxyCreationEnabled = false;
AGENT AgentObj = new AGENT();
AgentObj = db.AGENTs.Find(ID);
var name = AgentObj.AGENT_ID;
return("It worked");
}
private void loadLogin()
{
if (User.Identity.IsAuthenticated && Session["userType"] != null && (Session["aGENT"] != null || Session["lOCATION"] != null))
{
if (Session["userType"].ToString() == "Location")
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = (LOCATIONGROUP)Session["lOCATION"];
a_locationReport.Visible = true;
a_transferMoney.Visible = false;
a_foodItems.Visible = false;
a_editTransfer.Visible = true;
a_dailyReport.Visible = false;
//a_dailyReport.HRef = "ReportLocationWiseDaily.aspx";
a_compliance.Visible = false;
a_agentWiseReport.Visible = false;
a_agentCommReport.Visible = false;
a_administrator.Visible = false;
}
else
{
AGENT aGENT = new AGENT();
aGENT = (AGENT)Session["aGENT"];
if (aGENT.AGENTID == 4) //for admin
{
//a_transferMoney.Visible = false;
//a_dailyReport.HRef = "ReportAgentWiseDaily.aspx";
}
else
{
a_transferMoney.Visible = true;
a_locationReport.Visible = true;
a_foodItems.Visible = true;
a_editTransfer.Visible = true;
a_dailyReport.Visible = true;
//a_dailyReport.HRef = "ReportLocationWiseDaily.aspx";
a_compliance.Visible = false;
a_agentWiseReport.Visible = false;
a_agentCommReport.Visible = false;
a_administrator.Visible = false;
}
}
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
// GET: AGENTs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AGENT aGENT = db.AGENT.Find(id);
if (aGENT == null)
{
return(HttpNotFound());
}
return(View(aGENT));
}
public async Task <IHttpActionResult> DeleteAGENT(string id)
{
AGENT aGENT = await db.AGENT.FindAsync(id);
if (aGENT == null)
{
return(NotFound());
}
db.AGENT.Remove(aGENT);
await db.SaveChangesAsync();
return(Ok(aGENT));
}
// GET: AGENTs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AGENT aGENT = db.AGENT.Find(id);
if (aGENT == null)
{
return(HttpNotFound());
}
ViewBag.AdresseID = new SelectList(db.ADRESS, "Id", "Street", aGENT.AdresseID);
return(View(aGENT));
}
public AGENT GetAgentByID(int ID)
{
db.Configuration.ProxyCreationEnabled = false;
AGENT AgentObj = new AGENT();
try
{
AgentObj = db.AGENTs.Find(ID);
}
catch (Exception)
{
throw;
}
return(AgentObj);
}
public IHttpActionResult DeleteAgent(int ID)
{
db.Configuration.ProxyCreationEnabled = false;
AGENT Delete = new AGENT();
Delete = db.AGENTs.Where(zz => zz.AGENT_ID == ID).FirstOrDefault();
if (Delete == null)
{
return(NotFound());
}
db.AGENTs.Remove(Delete);
db.SaveChanges();
return(Ok(Delete));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AGENT = await _context.AGENT.FirstOrDefaultAsync(m => m.Agent_ID == id);
if (AGENT == null)
{
return(NotFound());
}
return(Page());
}
/// <summary>
/// This function for the admin login checking as this part only for the admin
/// </summary>
private void loadLogin()
{
if (User.Identity.IsAuthenticated && Session["userType"] != null && Session["aGENT"] != null)
{
AGENT aGENT = new AGENT();
aGENT = (AGENT)Session["aGENT"];
if (aGENT.AGENTID != 4 && Session["userType"].ToString() == "Agent") //for admin
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AGENT = await _context.AGENT.FindAsync(id);
if (AGENT != null)
{
_context.AGENT.Remove(AGENT);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public dynamic Test(int ID)
{
bool error = false;
db.Configuration.ProxyCreationEnabled = false;
AGENT AgentObj = new AGENT();
try
{
AgentObj = db.AGENTs.Find(ID);
var name = AgentObj.AGENT_ID;
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool ForegetPassword(string username)
{
string email;
string phone;
ACCOUNT account = db.ACCOUNT.FirstOrDefault(x => x.USERNAME == username);
if (account == null)
{
return(false);
}
MERCHANT merchant = db.MERCHANT.FirstOrDefault(x => x.MERCHANT_NUMBER == username);
if (merchant != null)
{
email = merchant.MERCHANT_EMAIL1;
phone = merchant.MERCHANT_TELEPHONE1;
}
else
{
AGENT agent = db.AGENT.FirstOrDefault(x => x.AGENT_NUMBER == username);
email = agent.AGENT_EMAIL_1;
phone = agent.AGENT_TELEPHONE1;
}
string temp = CreatePassword();
MailMessage mailMessag = new MailMessage(ConfigurationManager.AppSettings.Get("Email"), email);
mailMessag.Subject = "Gửi lại mật khẩu";
mailMessag.Body = "Mật khẩu mới của bạn là: " + temp;
SmtpClient client = new SmtpClient();
client.Send(mailMessag);
phone = "+84" + phone.Substring(1);
SendMessage(phone, "Bạn mới thay đổi passworld");
var passwordSalt = CreateSalt();
account.SALT = passwordSalt;
account.PASSWORD = EncryptPassword(temp, passwordSalt);
db.Entry(account).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
protected void updateFoodItemMaster(string transStatus)
{
// FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
//fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByID(Int32.Parse(Request.QueryString["fOODITEM_TRANSMASTERID"]));
AGENT aGENT = (AGENT)Session["aGENT"];
DateTime nullDate = DateTime.Parse(ConfigurationManager.AppSettings["NULL_DATE"].ToString());
FOODITEM_TRANSMASTER fOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
fOODITEM_TRANSMASTER = FOODITEM_TRANSMASTERManager.GetFOODITEM_TRANSMASTERByRefCode(hfReferenceCode.Value);
FOODITEM_TRANSMASTER tempFOODITEM_TRANSMASTER = new FOODITEM_TRANSMASTER();
tempFOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID = fOODITEM_TRANSMASTER.FOODITEM_TRANSMASTERID;
tempFOODITEM_TRANSMASTER.TDATE = fOODITEM_TRANSMASTER.TDATE;
tempFOODITEM_TRANSMASTER.CID = fOODITEM_TRANSMASTER.CID;
tempFOODITEM_TRANSMASTER.LID = fOODITEM_TRANSMASTER.LID;
tempFOODITEM_TRANSMASTER.AID = fOODITEM_TRANSMASTER.AID;
tempFOODITEM_TRANSMASTER.TOTALAMT = decimal.Parse(lblTotalAmount.Text);
if (transStatus == "SAME")
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = fOODITEM_TRANSMASTER.TRANSSTATUS;
}
else
{
tempFOODITEM_TRANSMASTER.TRANSSTATUS = transStatus;
}
tempFOODITEM_TRANSMASTER.REFCODE = fOODITEM_TRANSMASTER.REFCODE;
tempFOODITEM_TRANSMASTER.RECID = fOODITEM_TRANSMASTER.RECID;
tempFOODITEM_TRANSMASTER.RECDATE = fOODITEM_TRANSMASTER.RECDATE;
tempFOODITEM_TRANSMASTER.STOREID = fOODITEM_TRANSMASTER.STOREID;
tempFOODITEM_TRANSMASTER.CREATEDON = fOODITEM_TRANSMASTER.CREATEDON;
tempFOODITEM_TRANSMASTER.CREATEDBY = fOODITEM_TRANSMASTER.CREATEDBY;
tempFOODITEM_TRANSMASTER.UPDATEDON = DateTime.Now;
tempFOODITEM_TRANSMASTER.UPDATEDBY = aGENT.AGENTID;
bool result = FOODITEM_TRANSMASTERManager.UpdateFOODITEM_TRANSMASTER(tempFOODITEM_TRANSMASTER);
}
static void menu_OnMenuItemClicked(AGENT.Contrib.UI.Menu menu, MenuItem menuItem, DateTime time)
{
Debug.Print(menuItem.Title + " was clicked at " + time.ToString());
}
