public List <AgentNewCommon> GetAgentList(string AgentId, string username, string parentid = "")
{
string sql = "Exec sproc_agent_Detail_v2";
sql += " @flag='s'";
sql += " ,@agent_type='Distributor'";
sql += " ,@parent_Id=" + dao.FilterParameter(parentid);
sql += " ,@agent_id=" + dao.FilterParameter(AgentId);
sql += " ,@action_user="******"parent_id"].ToString(),
AgentID = item["agent_id"].ToString(),
AgentName = item["agent_name"].ToString(),
AgentOperationType = item["agent_operation_type"].ToString(),
AgentStatus = item["agent_status"].ToString(),
AgentMobileNumber = item["agent_mobile_no"].ToString()
};
lst.Add(AC);
}
}
return(lst);
}
public List <AgentNewCommon> GetWalletUserList(string DistId, string UserId = "")
{
var lst = new List <AgentNewCommon>();
string sql = "sproc_user_detail @flag ='v',@agent_id= " + dao.FilterString(DistId) + ",@user_id=" + dao.FilterString(UserId);
var dUser = dao.ExecuteDataTable(sql);
if (dUser != null)
{
foreach (DataRow dr in dUser.Rows)
{
AgentNewCommon Distri = new AgentNewCommon();
Distri.AgentID = dr["agent_id"].ToString();
Distri.UserID = dr["user_id"].ToString();
Distri.FullName = dr["full_name"].ToString();
Distri.UserEmail = dr["user_email"].ToString();
Distri.UserMobileNumber = dr["user_mobile_no"].ToString();
Distri.UserName = dr["user_name"].ToString();
//Distri.UserPassword = dr["password"].ToString();
Distri.UserType = dr["usr_type"].ToString();
Distri.IsPrimary = dr["is_primary"].ToString();
Distri.UserStatus = dr["status"].ToString();
lst.Add(Distri);
}
}
return(lst);
}
public ActionResult ManageAgent(string UserName, string agentId = "")
{
AgentNewModel AM = new AgentNewModel();
if (!string.IsNullOrEmpty(agentId))
{
AM.AgentID = agentId.DecryptParameter();
if (!string.IsNullOrEmpty(AM.AgentID))
{
AgentNewCommon AC = buss.GetAgentById(AM.AgentID, UserName.DecryptParameter());
AM = AC.MapObject <AgentNewModel>();
AM.AgentID = AM.AgentID.EncryptParameter();
}
}
LoadDropDownList(AM);
return(View(AM));
}
public ActionResult ManageAgent(AgentNewModel agentModel, HttpPostedFileBase Agent_Logo, HttpPostedFileBase Pan_Certiticate, HttpPostedFileBase Registration_Certificate)
{
var Agent_LogoPath = "";
var Pan_CertiticatePath = "";
var Registration_CertificatePath = "";
LoadDropDownList(agentModel);
if (ModelState.IsValid)
{
AgentNewCommon AC = new AgentNewCommon();
AC = agentModel.MapObject <AgentNewCommon>();
if (!string.IsNullOrEmpty(AC.AgentID))
{
if (string.IsNullOrEmpty(AC.AgentID.DecryptParameter()))
{
return(View(agentModel));
}
}
if (!string.IsNullOrEmpty(AC.ParentID))
{
if (string.IsNullOrEmpty(AC.ParentID.DecryptParameter()))
{
return(View(agentModel));
}
}
AC.ActionUser = ApplicationUtilities.GetSessionValue("UserName").ToString();
AC.IpAddress = ApplicationUtilities.GetIP();
if (Agent_Logo != null)
{
var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" };
var fileName = Path.GetFileName(Agent_Logo.FileName);
String timeStamp = DateTime.Now.ToString();
var ext = Path.GetExtension(Agent_Logo.FileName);
if (Agent_Logo.ContentLength > 1 * 1024 * 1024)//1 MB
{
this.ShowPopup(1, "Image Size must be less than 1MB");
return(View(agentModel));
}
if (allowedExtensions.Contains(ext.ToLower()))
{
string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' ');
string myfilename = "logo " + datet + "." + Agent_Logo.FileName;
Agent_LogoPath = Path.Combine(Server.MapPath("~/Content/assets/images/distributor_image"), myfilename);
AC.AgentLogo = myfilename;
}
else
{
this.ShowPopup(1, "File Must be .jpg,.png,.jpeg");
return(View(agentModel));
}
}
if (AC.AgentOperationType.ToUpper() == "BUSINESS")
{
if (Pan_Certiticate != null)
{
var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" };
var fileName = Path.GetFileName(Pan_Certiticate.FileName);
String timeStamp = DateTime.Now.ToString();
var ext = Path.GetExtension(Pan_Certiticate.FileName);
if (Pan_Certiticate.ContentLength > 1 * 1024 * 1024)//1 MB
{
this.ShowPopup(1, "Image Size must be less than 1MB");
return(View(agentModel));
}
if (allowedExtensions.Contains(ext.ToLower()))
{
string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' ');
string myfilename = "logo " + datet + "." + Pan_Certiticate.FileName;
Pan_CertiticatePath = Path.Combine(Server.MapPath("~/Content/assets/images/distributor_image"), myfilename);
AC.AgentPanCertificate = myfilename;
}
else
{
this.ShowPopup(1, "File Must be .jpg,.png,.jpeg");
return(View(agentModel));
}
}
if (Registration_Certificate != null)
{
var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" };
var fileName = Path.GetFileName(Registration_Certificate.FileName);
String timeStamp = DateTime.Now.ToString();
var ext = Path.GetExtension(Registration_Certificate.FileName);
if (Registration_Certificate.ContentLength > 1 * 1024 * 1024)//1 MB
{
this.ShowPopup(1, "Image Size must be less than 1MB");
return(View(agentModel));
}
if (allowedExtensions.Contains(ext.ToLower()))
{
string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' ');
string myfilename = "logo " + datet + "." + Registration_Certificate.FileName;
Registration_CertificatePath = Path.Combine(Server.MapPath("~/Content/assets/images/distributor_image"), myfilename);
AC.AgentRegistrationCertificate = myfilename;
//Registration_Certificate.SaveAs(path);
}
else
{
this.ShowPopup(1, "File Must be .jpg,.png,.jpeg");
return(View(agentModel));
}
}
}
CommonDbResponse dbresp = buss.ManageAgent(AC);
if (dbresp.Code == 0)
{
this.ShowPopup(0, dbresp.Message);
return(RedirectToAction("Index"));
}
agentModel.Msg = dbresp.Message;
}
this.ShowPopup(1, "Error " + agentModel.Msg);
return(View(agentModel));
}
public CommonDbResponse ManageAgent(AgentNewCommon AC)
{
return(repo.ManageAgent(AC));
}
public CommonDbResponse ManageAgent(AgentNewCommon AC)
{
string sql = "sproc_agent_Detail_v2 ";
sql += "@flag='" + (string.IsNullOrEmpty(AC.AgentID) ? "i" : "u") + "'";
sql += " ,@agent_type='Distributor'";
sql += " ,@agent_id=" + dao.FilterString(AC.AgentID);
sql += " ,@parent_id=" + dao.FilterString(AC.ParentID);
sql += " ,@agent_operation_type=" + dao.FilterString(AC.AgentOperationType);
sql += " ,@agent_commission_type=" + AC.AgentCommissionType;
sql += " ,@agent_mobile_no=" + dao.FilterString(AC.AgentMobileNumber);
//sql += " ,@agent_contract_date_bs=" + dao.FilterString(AC.AgentContractDate_BS);
sql += " ,@agent_country=" + dao.FilterString(AC.AgentCountry);
sql += " ,@agent_province=" + dao.FilterString(AC.AgentProvince);
sql += " ,@agent_district=" + dao.FilterString(AC.AgentDistrict);
sql += " ,@agent_local_body=" + dao.FilterString(AC.AgentVDC_Muncipality);
sql += " ,@agent_ward_number=" + dao.FilterString(AC.AgentWardNo);
sql += " ,@agent_street=" + dao.FilterString(AC.AgentStreet);
sql += " ,@agent_available_balance=" + dao.FilterString(AC.AgentBalance);
sql += " ,@agent_logo=" + dao.FilterString(AC.AgentLogo);
//contact Person
sql += " ,@contact_person_name=" + dao.FilterString(AC.ContactPersonName);
sql += " ,@contact_person_mobile_number=" + dao.FilterString(AC.ContactPersonMobileNumber);
sql += " ,@contact_person_ID_type=" + dao.FilterString(AC.ContactPersonIdType);
sql += " ,@contact_person_ID_no=" + dao.FilterString(AC.ContactPersonIdNumber);
//sql += " ,@contact_person_id_issue_country=" + dao.FilterString(AC.ContactPersonIdIssueCountry);
sql += " ,@contact_person_id_issue_district=" + dao.FilterString(AC.ContactPersonIdIssueDistrict);
sql += " ,@contact_person_Id_issue_date=" + dao.FilterString(AC.ContactPersonIdIssueDate);
sql += " ,@contact_person_id_issue_date_nepali=" + dao.FilterString(AC.ContactPersonIdIssueDate_BS);
sql += " ,@contact_person_id_expiry_date=" + dao.FilterString(AC.ContactPersonIdExpiryDate);
sql += " ,@contact_person_id_expiry_date_nepali=" + dao.FilterString(AC.ContactPersonIdExpiryDate_BS);
sql += " ,@action_user="******" ,@action_ip=" + dao.FilterString(AC.IpAddress);
sql += " ,@action_platform=''";// + dao.FilterString(AC.IpAddress);
if (AC.AgentOperationType.ToUpper() == "BUSINESS")
{
sql += " ,@agent_phone_number=" + dao.FilterString(AC.AgentPhoneNumber);
sql += " ,@agent_email=" + dao.FilterString(AC.AgentEmail);
sql += " ,@agent_web_url=" + dao.FilterString(AC.AgentWebUrl);
sql += " ,@agent_registration_no=" + dao.FilterString(AC.AgentRegistrationNumber);
sql += " ,@agent_Pan_no=" + dao.FilterString(AC.AgentPanNumber);
sql += " ,@agent_contract_date=" + dao.FilterString(AC.AgentContractDate);
sql += " ,@agent_reg_certificate=" + dao.FilterString(AC.AgentRegistrationCertificate);
sql += " ,@agent_pan_Certificate=" + dao.FilterString(AC.AgentPanCertificate);
}
if (string.IsNullOrEmpty(AC.AgentID))
{
//user Information
sql += " ,@agent_name=" + dao.FilterString(AC.AgentName);
sql += " ,@agent_credit_limit=" + dao.FilterString(AC.AgentCreditLimit);
sql += " ,@user_name=" + dao.FilterString(AC.UserName);
sql += " ,@password="******" ,@confirm_password="******" ,@first_name=" + dao.FilterString(AC.FirstName);
sql += " ,@middle_name=" + dao.FilterString(AC.MiddleName);
sql += " ,@last_name=" + dao.FilterString(AC.LastName);
sql += " ,@user_mobile_number=" + dao.FilterString(AC.UserMobileNumber);
sql += " ,@user_email=" + dao.FilterString(AC.UserEmail);
sql += " ,@role_id='8'";
}
return(dao.ParseCommonDbResponse(sql));
}
public AgentNewCommon GetAgentById(string AgentId, string username)
{
string sql = "Exec sproc_agent_Detail_v2";
sql += " @flag='ds'";
sql += ", @agent_id=" + dao.FilterString(AgentId);
sql += ", @action_user="******"agent_type"].ToString();
AC.AgentID = dt["agent_id"].ToString();
AC.ParentID = dt["parent_id"].ToString();
AC.AgentOperationType = dt["agent_operation_type"].ToString();
string test = dt["is_auto_commission"].ToString();
AC.AgentCommissionType = dt["is_auto_commission"].ToString().ToUpper() == "TRUE" ? true : false;//dt[""].ToString();
AC.AgentName = dt["agent_name"].ToString();
AC.AgentPhoneNumber = dt["agent_phone_no"].ToString();
AC.AgentMobileNumber = dt["agent_mobile_no"].ToString();
AC.AgentEmail = dt["agent_email_address"].ToString();
AC.AgentWebUrl = dt["agent_web_url"].ToString();
AC.AgentRegistrationNumber = dt["agent_registration_no"].ToString();
AC.AgentPanNumber = dt["agent_pan_no"].ToString();
AC.AgentContractDate = dt["agent_contract_local_date"].ToString();
AC.AgentContractDate_BS = dt["agent_contract_nepali_date"].ToString();
AC.AgentCountry = dt["agent_country"].ToString();
AC.AgentProvince = dt["agent_province"].ToString();
AC.AgentDistrict = dt["agent_district"].ToString();
AC.AgentVDC_Muncipality = dt["agent_localbody"].ToString();
AC.AgentWardNo = dt["agent_wardno"].ToString();
AC.AgentStreet = dt["agent_address"].ToString();
AC.AgentCreditLimit = dt["agent_credit_limit"].ToString();
AC.AgentBalance = dt["available_balance"].ToString();
AC.AgentLogo = dt["agent_logo_img"].ToString();
AC.AgentRegistrationCertificate = dt["agent_registeration_cert_image"].ToString();
AC.AgentPanCertificate = dt["agent_pan_cert_image"].ToString();
AC.UserID = dt["user_id"].ToString();
AC.UserName = dt["user_name"].ToString();
//AC.Password = dt[""].ToString();
//AC.ConfirmPassword = dt[""].ToString();
AC.FirstName = dt["first_name"].ToString();
AC.MiddleName = dt["middle_name"].ToString();
AC.LastName = dt["last_name"].ToString();
AC.UserMobileNumber = dt["user_mobile_no"].ToString();
AC.UserEmail = dt["user_email"].ToString();
AC.ContactPersonName = dt["contact_person_name"].ToString();
AC.ContactPersonMobileNumber = dt["contact_person_mobile_no"].ToString();
AC.ContactPersonIdType = dt["contact_person_id_type"].ToString();
AC.ContactPersonIdNumber = dt["contact_person_id_no"].ToString();
//AC.ContactPersonIdIssueCountry = dt[""].ToString();
AC.ContactPersonIdIssueDistrict = dt["contact_id_issued_district"].ToString();
AC.ContactPersonIdIssueDate = dt["contact_id_issue_local_date"].ToString();
AC.ContactPersonIdIssueDate_BS = dt["contact_id_issued_bs_date"].ToString();
AC.ContactPersonIdExpiryDate = dt["contact_id_expiry_local_date"].ToString();
AC.ContactPersonIdExpiryDate_BS = dt["contact_id_expiry_bs_date"].ToString();
}
return(AC);
}
