public ActionResult Create([Bind(Include = "CustomerId,VendorName,VendorOrg,VendorMob,VendorAMob,VendorEmail,VendorRepDesc,VendorAdd1,VendorAdd2,VendorCity,VendorState,VendorCountry,VendorZipCode,VendorTaxDet,VendorStatus,VendorDesc")] VendorMaster vendor)
{
VendorMaster v = new VendorMaster();
if (ModelState.IsValid)
{
v.EmployeeID = Convert.ToInt32(@Session["employeecode"]);
v.VendorName = vendor.VendorName;
v.VendorOrg = vendor.VendorOrg;
v.VendorMob = vendor.VendorMob;
v.VendorAMob = vendor.VendorAMob;
v.VendorEmail = vendor.VendorEmail;
v.VendorRepDesc = vendor.VendorRepDesc;
v.VendorAdd1 = vendor.VendorAdd1;
v.VendorAdd2 = vendor.VendorAdd2;
v.VendorCity = vendor.VendorCity;
v.VendorState = vendor.VendorState;
v.VendorCountry = vendor.VendorCountry;
v.VendorZipCode = vendor.VendorZipCode;
v.VendorTaxDet = vendor.VendorTaxDet;
v.VendorStatus = vendor.VendorStatus;
v.VendorDesc = vendor.VendorDesc;
v.CreatedDate = DateTime.Now;
db.VendorMasters.Add(v);
db.SaveChanges();
}
return(RedirectToAction("Create"));
}
public ActionResult Edit([Bind(Include = "CustomerId,RecordId,VendorName,VendorOrg,VendorMob,VendorAMob,VendorEmail,VendorRepDesc,VendorAdd1,VendorAdd2,VendorCity,VendorState,VendorCountry,VendorZipCode,VendorTaxDet,VendorStatus,VendorDesc")] VendorMaster vendor)
{
VendorMaster v = (from c in db.VendorMasters
where c.RecordId == vendor.RecordId
select c).FirstOrDefault();
if (ModelState.IsValid)
{
v.EmployeeID = Convert.ToInt32(@Session["employeecode"]);
v.VendorName = vendor.VendorName;
v.VendorOrg = vendor.VendorOrg;
v.VendorMob = vendor.VendorMob;
v.VendorAMob = vendor.VendorAMob;
v.VendorEmail = vendor.VendorEmail;
v.VendorRepDesc = vendor.VendorRepDesc;
v.VendorAdd1 = vendor.VendorAdd1;
v.VendorAdd2 = vendor.VendorAdd2;
v.VendorCity = vendor.VendorCity;
v.VendorState = vendor.VendorState;
v.VendorCountry = vendor.VendorCountry;
v.VendorZipCode = vendor.VendorZipCode;
v.VendorTaxDet = vendor.VendorTaxDet;
v.VendorStatus = vendor.VendorStatus;
v.VendorDesc = vendor.VendorDesc;
v.CreatedDate = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("ViewAll"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VendorMaster ven = db.VendorMasters.Find(id);
var vendorList = (from a in db.VendorMasters
join b in db.COUNTRYLISTs on a.VendorCountry equals b.ID
join c in db.StatusMasters on a.VendorStatus equals c.RecordId
join d in db.UserMasters on a.EmployeeID equals d.EmployeeCode
join e in db.StateMasters on a.VendorState equals e.Id
join f in db.CityMasters on a.VendorState equals f.StateId
where a.VendorCity == f.Id
select new VendorDetails()
{
vendor = a, country = b, status = c, empName = d.UserName, city = f.City, state = e.State
}).Single();
if (ven == null)
{
return(HttpNotFound());
}
return(View(vendorList));
}
protected void ddlVendor_SelectedIndexChanged(object sender, EventArgs e)
{
Int64 id = Int64.Parse(ddlVendor.SelectedValue.ToString());
try
{
VendorMaster vm = new VendorMaster();
DataTable dt = new DataTable();
Cls_VendorMaster_b clsbrand = new Cls_VendorMaster_b();
vm = clsbrand.SelectById(id);
txtMobile.Text = vm.MobileNo1.ToString();
txtEmail.Text = vm.email.ToString();
//txtCity.Text = vm.fk_cityId.ToString();
//txtState.Text = vm.fk_stateId.ToString();
//txtCountry.Text = vm.fk_countryId.ToString();
txtCity.Text = vm.city.ToString();
txtState.Text = vm.state.ToString();
txtCountry.Text = vm.country.ToString();
txtAddress.Text = vm.Address1.ToString();
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
//return null;
}
finally { con.Close(); }
}
public ActionResult DeleteConfirmed(int id)
{
VendorMaster ven = db.VendorMasters.Find(id);
db.VendorMasters.Remove(ven);
db.SaveChanges();
return(RedirectToAction("ViewAll"));
}
private void ModeAction()
{
try
{
switch (Mode)
{
case PageMode.Add:
{
Pk = false;
Ck = true;
modeContent = "Save";
}
break;
case PageMode.Modify:
{
Pk = true;
Ck = false;
modeContent = "Update";
}
break;
case PageMode.Delete:
{
Pk = true;
Ck = false;
modeContent = "Delete";
}
break;
case PageMode.Browse:
{
Pk = true;
Ck = false;
modeContent = "Ok";
}
break;
}
objVendorMaster = new VendorMaster();
if (Mode != PageMode.Add)
{
lstVendor = pxy.GetVendorList();
}
}
catch (Exception ex)
{
UIHelper.ShowErrorMessage(ex.Message);
}
}
public Int64 Insert(VendorMaster objVendorMaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "vendorMaster_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@vid";
param.Value = objVendorMaster.vid;
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@vendorName", objVendorMaster.vendorName);
cmd.Parameters.AddWithValue("@Address1", objVendorMaster.Address1);
cmd.Parameters.AddWithValue("@Address2", objVendorMaster.Address2);
cmd.Parameters.AddWithValue("@MobileNo1", objVendorMaster.MobileNo1);
cmd.Parameters.AddWithValue("@MobileNo2", objVendorMaster.MobileNo2);
cmd.Parameters.AddWithValue("@email", objVendorMaster.email);
cmd.Parameters.AddWithValue("@landline", objVendorMaster.landline);
cmd.Parameters.AddWithValue("@fk_agentId", objVendorMaster.fk_agentId);
cmd.Parameters.AddWithValue("@fk_countryId", objVendorMaster.fk_countryId);
cmd.Parameters.AddWithValue("@fk_stateId", objVendorMaster.fk_stateId);
cmd.Parameters.AddWithValue("@fk_cityId", objVendorMaster.fk_cityId);
cmd.Parameters.AddWithValue("@img", objVendorMaster.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);
}
private static InvoiceReportSummary GetDetails(InvoiceDetailsMaster IM, VendorMaster VM)
{
return(new InvoiceReportSummary()
{
InvoiceNo = IM.InvoiceNo,
PartyName = IM.PartysName,
Address = IM.Address,
InvoiceDate = IM.InvoiceDate,
OrderNo = IM.OrderId,
OrderDate = IM.OrderDate,
GSTNo = VM.Gstno,
PanNo = VM.PanNo,
CommissionTab = VM.CommissionTab
});
}
public async Task <IActionResult> UpSertVendor(VendorMaster model)
{
if (model.Id == 0)
{
var createModel = CommanCRUDHelper.CommanCreateCode(model, 1);
var response = await _IVendorMasterService.CreateEntity(createModel);
return(Json(ResponseHelper.GetResponseMessage(response)));
}
var updateModel = CommanCRUDHelper.CommanUpdateCode(model, 1);
var updateRespose = await _IVendorMasterService.Update(updateModel);
return(Json(ResponseHelper.GetResponseMessage(updateRespose)));
}
public void Post([FromBody] VendorMaster value)
{
try
{
bool result = _mediator.Send(new CreateVendorCommand(value)).Result;
if (result)
{
//Record saved succesfully, publishing event now
_mediator.Publish(new CreateVendorNotification(value));
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
}
}
public int insertupdateVendor(VendorMaster vendor, char Flag)
{
int VendorID = 0;
try
{
if (vendor != null)
{
conn.Open();
MySqlTransaction tran = conn.BeginTransaction();
MySqlCommand cmd = new MySqlCommand("sp_insertupdateVendorMaster", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("p_Flag", Flag);
cmd.Parameters.AddWithValue("p_Vendor_ID", vendor.VendorID);
cmd.Parameters.AddWithValue("p_Vendor_Name", vendor.VendorName);
cmd.Parameters.AddWithValue("p_Contact_Person", vendor.ContactPerson);
cmd.Parameters.AddWithValue("p_Contact_Number", vendor.ContactNumber);
cmd.Parameters.AddWithValue("p_Start_Date", vendor.VendorStartDate);
cmd.Parameters.AddWithValue("p_End_Date", vendor.VendorEndDate);
cmd.Parameters.AddWithValue("p_Website", vendor.VendorWebsite);
cmd.Parameters.AddWithValue("p_Auditing_Frequency", vendor.VendorAuditingFrequency);
cmd.Parameters.AddWithValue("p_Vendor_Type", vendor.VendorType);
cmd.Parameters.AddWithValue("p_Last_Updated_Date", vendor.LastUpdatedDate);
cmd.Parameters.AddWithValue("p_Company_ID", vendor.OrgCompanyID);
cmd.Parameters.AddWithValue("p_User_ID", vendor.UserID);
cmd.Parameters.AddWithValue("p_Is_Active", vendor.IsActive);
cmd.Parameters.AddWithValue("p_Is_Delete", vendor.IsDelete);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
object objvendorid = cmd.ExecuteScalar();
if (Convert.ToInt32(objvendorid) != 0)
{
VendorID = Convert.ToInt32(objvendorid);
}
tran.Commit();
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
return(VendorID);
}
public VendorViewModel(int PageMode)
{
try
{
Mode = PageMode;
if (pxy == null)
{
pxy = new DataServiceClient();
}
objVendorMaster = new VendorMaster();
cmdVendorDetails = new DelegateCommand <object>(cmdVendorDetails_Execute, cmdVendorDetails_CanExecute);
cmdSave = new DelegateCommand <object>(cmdSave_Execute, cmdSave_CanExecute);
cmdClear = new DelegateCommand <object>(cmdClear_Execute);
ModeAction();
}
catch (FaultException ex)
{
UIHelper.ShowErrorMessage(ex.Message);
}
}
public int updateVendor(VendorMaster vendor)
{
int VendorID = 0;
bool updateResult = false;
try
{
VendorHelper vendorhelper = new VendorHelper();
VendorID = vendorhelper.insertupdateVendor(vendor, 'U');
if (VendorID > 0)
{
updateResult = true;
}
}
catch
{
throw;
}
return(VendorID);
}
public bool SaveVender(VendorModel model)
{
try
{
VendorMaster vendorModel = new VendorMaster();
vendorModel.name = model.name;
vendorModel.vendorType = model.vendorType;
vendorModel.address = model.address;
vendorModel.city = model.city;
vendorModel.pincode = model.pincode;
vendorModel.state = model.state;
vendorModel.STDcode = model.STDcode;
vendorModel.phoneno = model.phoneno;
vendorModel.mobileno = model.mobileno;
vendorModel.emailid = model.emailid;
vendorModel.emailalert = model.emailalert;
vendorModel.PAN = model.PAN;
vendorModel.GSTIN = model.GSTIN;
vendorModel.referencename = model.referencename;
vendorModel.referphoneno = model.referphoneno;
vendorModel.refermobileno = model.refermobileno;
vendorModel.creditdays = model.creditdays;
vendorModel.creditamount = model.creditamount;
vendorModel.bankname = model.bankname;
vendorModel.bankbranch = model.bankbranch;
vendorModel.IFSC = model.IFSC;
vendorModel.accountno = model.accountno;
vendorModel.chequename = model.chequename;
vendorModel.fileupload = model.fileupload;
vendorModel.isActive = true;
tRSEntities4.VendorMasters.Add(vendorModel);
tRSEntities4.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public void BindVendor(Int64 BankId)
{
VendorMaster objVendorMaster = (new Cls_VendorMaster_b().SelectById(BankId));
if (objVendorMaster != null)
{
//BindAgent();
BindCountry();
//ddlAgent.SelectedValue = objVendorMaster.fk_agentId.ToString();
ddlCountry.SelectedValue = objVendorMaster.fk_countryId.ToString();
ddlCountry_SelectedIndexChanged(null, null);
ddlState.SelectedValue = objVendorMaster.fk_stateId.ToString();
ddlState_SelectedIndexChanged(null, null);
ddlCity.SelectedValue = objVendorMaster.fk_cityId.ToString();
txtvendorName.Text = objVendorMaster.vendorName;
txtAddress1.Text = objVendorMaster.Address1;
txtAddress2.Text = objVendorMaster.Address2;
txtMobileNo1.Text = objVendorMaster.MobileNo1;
txtMobileNo2.Text = objVendorMaster.MobileNo2;
txtLandline.Text = objVendorMaster.landline;
txtEmail.Text = objVendorMaster.email;
if (!string.IsNullOrEmpty(objVendorMaster.img))
{
imgCategory.Visible = true;
ViewState["fileName"] = objVendorMaster.img;
imgCategory.ImageUrl = categoryFrontPath + objVendorMaster.img;
btnImageUpload.Visible = false;
btnRemove.Visible = true;
}
else
{
btnImageUpload.Visible = true;
}
}
}
public ActionResult Edit(int?id)
{
ViewBag.Status = new SelectList(db.StatusMasters, "RecordId", "StatusName");
ViewBag.State = new SelectList(GetState(), "Value", "Text");
ViewBag.Country = new SelectList(GetCountry(), "Value", "Text");
List <SelectListItem> emptyList = new List <SelectListItem>();
emptyList.Insert(0, new SelectListItem {
Text = "Select City", Value = ""
});
ViewBag.Empty = new SelectList(emptyList, "Value", "Text");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VendorMaster ven = db.VendorMasters.Find(id);
if (ven == null)
{
return(HttpNotFound());
}
return(View(ven));
}
public void Update(VendorMaster vendorMaster)
{
throw new NotImplementedException();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
VendorMaster ds = new VendorMaster();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "VendorMasterDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
VendorMaster ds = new VendorMaster();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public virtual int Update(VendorMaster dataSet) {
return this.Adapter.Update(dataSet, "VendorMaster");
}
public virtual int Update(VendorMaster.VendorMasterDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public IHttpActionResult uploadVendorData()
{
try
{
var httpRequest = HttpContext.Current.Request;
var serverPath = HttpContext.Current.Server.MapPath("~/SCMDocs");
string parsedFileName = "";
if (httpRequest.Files.Count > 0)
{
var Id = httpRequest.Files.AllKeys[0];
var postedFile = httpRequest.Files[0];
parsedFileName = string.Format(DateTime.Now.Year.ToString() + "\\" + DateTime.Now.ToString("MMM") + "\\" + Id + "\\" + ToValidFileName(postedFile.FileName));
serverPath = serverPath + string.Format("\\" + DateTime.Now.Year.ToString() + "\\" + DateTime.Now.ToString("MMM")) + "\\" + Id;
var filePath = Path.Combine(serverPath, ToValidFileName(postedFile.FileName));
if (!Directory.Exists(serverPath))
{
Directory.CreateDirectory(serverPath);
}
postedFile.SaveAs(filePath);
DataTable dtexcel = new DataTable();
bool hasHeaders = false;
string HDR = hasHeaders ? "Yes" : "No";
string strConn;
if (filePath.Substring(filePath.LastIndexOf('.')).ToLower() == ".xlsx")
{
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;HDR=" + HDR + ";IMEX=0\"";
}
else
{
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=" + HDR + ";IMEX=0\"";
}
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
DataRow schemaRow = schemaTable.Rows[0];
string sheet = schemaRow["TABLE_NAME"].ToString();
if (!sheet.EndsWith("_"))
{
string query = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter daexcel = new OleDbDataAdapter(query, conn);
dtexcel.Locale = CultureInfo.CurrentCulture;
daexcel.Fill(dtexcel);
}
conn.Close();
int iSucceRows = 0;
YSCMEntities obj = new YSCMEntities();
foreach (DataRow row in dtexcel.Rows)
{
var vendorcode = row["Vendor Code"].ToString();
VendorMaster vendorMaster = obj.VendorMasters.Where(li => li.VendorCode == vendorcode).FirstOrDefault();
if (vendorMaster != null)
{
VendormasterModel vendorModel = new VendormasterModel();
vendorModel.Vendorid = vendorMaster.Vendorid;
vendorModel.VendorName = row["Vendor Name"].ToString();
string Emailids = "";
if (!string.IsNullOrEmpty(row["Email Id 1"].ToString()))
{
Emailids = row["Email Id 1"].ToString();
}
if (!string.IsNullOrEmpty(row["Email Id 2"].ToString()))
{
Emailids += "," + row["Email Id 2"].ToString();
}
if (!string.IsNullOrEmpty(row["Email Id 3"].ToString()))
{
Emailids += "," + row["Email Id 3"].ToString();
}
if (!string.IsNullOrEmpty(row["Email Id 4"].ToString()))
{
Emailids += "," + row["Email Id 4"].ToString();
}
vendorModel.Emailid = Emailids;
vendorModel.ContactNumber = row["contact number"].ToString();
vendorModel.ContactPerson = row["contact person"].ToString();
this._mprBusenessAcess.addNewVendor(vendorModel);
}
}
int succRecs = iSucceRows;
}
return(Ok(parsedFileName));
}
catch (Exception e)
{
log.ErrorMessage("MPRController", "uploadVendorData", e.Message.ToString());
return(Ok(e));
}
}
public CreateVendorCommand(VendorMaster vendorMaster)
{
VendorMaster = vendorMaster;
}
public VendorMaster SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
VendorMaster objVendorMaster = new VendorMaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "vendorMaster_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@vid", id);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
//vid, vendorName, Address1, Address2, MobileNo1, MobileNo2, email, landline, fk_countryId, fk_stateId, fk_cityId, createddate, isdelete, isactive
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objVendorMaster.vid = Convert.ToInt64(ds.Tables[0].Rows[0]["vid"]);
objVendorMaster.fk_agentId = Convert.ToInt64(ds.Tables[0].Rows[0]["fk_agentId"]);
objVendorMaster.vendorName = Convert.ToString(ds.Tables[0].Rows[0]["vendorName"]);
objVendorMaster.Address1 = Convert.ToString(ds.Tables[0].Rows[0]["Address1"]);
objVendorMaster.Address2 = Convert.ToString(ds.Tables[0].Rows[0]["Address2"]);
objVendorMaster.MobileNo1 = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo1"]);
objVendorMaster.MobileNo2 = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo2"]);
objVendorMaster.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]);
objVendorMaster.landline = Convert.ToString(ds.Tables[0].Rows[0]["landline"]);
//objVendorMaster.fk_agentId = Convert.ToInt64(ds.Tables[0].Rows[0]["fk_agentId"]);
objVendorMaster.fk_countryId = Convert.ToString(ds.Tables[0].Rows[0]["fk_countryId"]);
objVendorMaster.fk_stateId = Convert.ToString(ds.Tables[0].Rows[0]["fk_stateId"]);
objVendorMaster.fk_cityId = Convert.ToString(ds.Tables[0].Rows[0]["fk_cityId"]);
objVendorMaster.createddate = Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]);
objVendorMaster.country = Convert.ToString(ds.Tables[0].Rows[0]["countryname"]);
objVendorMaster.state = Convert.ToString(ds.Tables[0].Rows[0]["statename"]);
objVendorMaster.city = Convert.ToString(ds.Tables[0].Rows[0]["cityname"]);
//objVendorMaster.img = Convert.ToString(ds.Tables[0].Rows[0]["img"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objVendorMaster);
}
public CreateVendorNotification(VendorMaster vendorVM)
{
_vendorVM = vendorVM;
}
public VendorMaster Add(VendorMaster vendorMaster)
{
var res = _dbContext.Add(vendorMaster);
return(res.Entity);
}
public void Update(VendorMaster vendorMaster)
{
_dbContext.Entry(vendorMaster).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objVendor = null;
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
VendorMaster objVendorMaster = new VendorMaster();
//objVendorMaster.fk_agentId = Convert.ToInt64(ddlAgent.SelectedValue.ToString());
objVendorMaster.fk_agentId = 0;
objVendorMaster.fk_countryId = ddlCountry.SelectedValue.ToString();
objVendorMaster.fk_stateId = ddlState.SelectedValue.ToString();
objVendorMaster.fk_cityId = ddlCity.SelectedValue.ToString();
objVendorMaster.vendorName = txtvendorName.Text.Trim();
objVendorMaster.Address1 = txtAddress1.Text.Trim();
objVendorMaster.Address2 = txtAddress2.Text.Trim();
objVendorMaster.MobileNo1 = txtMobileNo1.Text.Trim();
objVendorMaster.MobileNo2 = txtMobileNo2.Text.Trim();
objVendorMaster.landline = txtLandline.Text.Trim();
objVendorMaster.email = txtEmail.Text.Trim();
if (ViewState["fileName"] != null)
{
objVendorMaster.img = ViewState["fileName"].ToString();
}
if (Request.QueryString["id"] != null)
{
objVendorMaster.vid = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_VendorMaster_b().Update(objVendorMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageVendor.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Vendor Not Updated";
BindVendor(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_VendorMaster_b().Insert(objVendorMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageVendor.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Vendor Not Inserted";
}
}
}
