public int DA_ValidateVendor(VendorEntities objVendorDetails)
{
int val = 0;
DataTable dt = new DataTable();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.ValidateVendor, con);
cmd.Parameters.AddWithValue("@AadharCard", objVendorDetails.AadharCard);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
val = 1;
}
else
{
val = 0;
}
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
finally
{
con.Close();
}
return(val);
}
public int BAaddVendorDetails(VendorEntities objVendorDetails)
{
DAVendor objaddvendorDA = new DAVendor();
int returnValue = objaddvendorDA.DAaddVendorDetails(objVendorDetails);
return(returnValue);
}
public int UpdateVendor(VendorEntities vendor)
{
if (vendor != null)
{
return(repository.UpdateVendor(vendor));
}
else
{
return(0);
}
}
public Guid CreateVendorFromWO(VendorEntities vendor)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
UOWVendor vendorObj = new UOWRepository.UOWVendor();
try
{
var newVendor = new Vendor();
if (vendor.Email != null && (!vendorObj.IsVendorExists(vendor.Email)))
{
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = vendor.VendorName;
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = "1";
newVendor.TaxIdisEIN = "Y";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = "Y";
newVendor.AddressVerifiedFlag = "Y";
db.Vendors.Add(newVendor);
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = "Y";
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
db.ClientVendors.Add(clientVendor);
db.SaveChanges();
}
return(newVendor.VendorId);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public int DA_EditVendor(VendorEntities objVendordetails)
{
int val = 0;
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.UpdateVendor, con);
cmd.Parameters.AddWithValue("@VendorId", objVendordetails.VendorId);
val = cmd.ExecuteNonQuery();
con.Close();
return(val);
}
protected void Button1_Click1(object sender, EventArgs e)
{
int validate = 0;
VendorEntities objVendorDetails = new VendorEntities();
try
{
//objVendorDetails.VendorId = Convert.ToInt32(VendorId.Text);
objVendorDetails.CompanyName = CompanyName.Text;
objVendorDetails.VendorName = VendorName.Text;
objVendorDetails.MobileNo = MobileNo.Text;
objVendorDetails.Address = Address.Text;
objVendorDetails.EmailId = EmailId.Text;
objVendorDetails.VendorGSTNo = VendorGSTNo.Text;
objVendorDetails.BankAccountNo = BankAccountNo.Text;
objVendorDetails.BankName = BankName.Text;
objVendorDetails.Branch = Branch.Text;
objVendorDetails.IFSCCode = IFSCCode.Text;
objVendorDetails.PanCard = PanCard.Text;
objVendorDetails.AadharCard = AadharCard.Text;
}
catch (Exception ex)
{
ex.ToString();
}
//BAL
BAVendor2 objVendorBA = new BAVendor2();
validate = objVendorBA.BA_ValidateVendor(objVendorDetails);
if (validate > 0)
{
Response.Write("<script> alert('Data already exist!')</script>");
}
else
{
int rValue = objVendorBA.BAaddVendorDetails(objVendorDetails);
if (rValue > 0)
{
Response.Write("<script>alert('success')</script>");
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
}
protected void gd_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int VendorId = Convert.ToInt16(gd.DataKeys[e.RowIndex].Value);
VendorEntities obj_BEVendor = new VendorEntities();
obj_BEVendor.VendorId = VendorId;
BAVendor2 obj_BAVendor = new BAVendor2();
int val = obj_BAVendor.BA_EditVendor(obj_BEVendor);
if (val > 0)
{
Response.Write("<script>alert('Vendor deleted successfully')</script>");
GetTableDetails();
}
else
{
Response.Write("<script>alert('Error Occured')</script>");
}
}
public int DAaddVendorDetails(VendorEntities objVendorDetails)
{
int ReturnValue = 0;
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.InsertVendor, con);
//cmd.Parameters.AddWithValue("@VendorId", objVendorDetails.VendorId);
cmd.Parameters.AddWithValue("@CompanyName", objVendorDetails.CompanyName);
cmd.Parameters.AddWithValue("@VendorName", objVendorDetails.VendorName);
cmd.Parameters.AddWithValue("@MobileNo", objVendorDetails.MobileNo);
cmd.Parameters.AddWithValue("@Address", objVendorDetails.Address);
cmd.Parameters.AddWithValue("@EmailId", objVendorDetails.EmailId);
cmd.Parameters.AddWithValue("@VendorGSTNo", objVendorDetails.VendorGSTNo);
cmd.Parameters.AddWithValue("@BankAccountNo", objVendorDetails.BankAccountNo);
cmd.Parameters.AddWithValue("@BankName", objVendorDetails.BankName);
cmd.Parameters.AddWithValue("@Branch", objVendorDetails.Branch);
cmd.Parameters.AddWithValue("@IFSCCode", objVendorDetails.IFSCCode);
cmd.Parameters.AddWithValue("@PanCard", objVendorDetails.PanCard);
cmd.Parameters.AddWithValue("@AadharCard", objVendorDetails.AadharCard);
ReturnValue = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
finally
{
con.Close();
}
return(ReturnValue);
}
public int BA_EditVendor(VendorEntities objVendordetails)
{
DAVendor objVendorDA = new DAVendor();
return(objVendorDA.DA_EditVendor(objVendordetails));
}
public Guid CreateVendor(VendorEntities vendor)
{
return(repository.CreateVendor(vendor));
}
public Guid CreateVendor(VendorEntities vendor)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities db = new FacilitiesEntities())
{
UOWVendor vendorObj = new UOWRepository.UOWVendor();
try
{
vendor.UserEntity.Email = vendor.Email;
var newVendor = new Vendor();
if (vendor.Email != null && (!vendorObj.IsVendorExists(vendor.Email)))
{
if (vendor.UserEntity.FirstName != null && vendor.UserEntity.FirstName.Trim().Length > 0)
{
if (vendor.UserEntity.LastName == null)
{
vendor.UserEntity.LastName = "";
}
var U = VM_User.AddDataInUser <User>(vendor.UserEntity);
if (U != null)
{
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = (vendor.VendorName != null && vendor.VendorName.Trim().Length > 0) ? vendor.VendorName : vendor.UserEntity.FirstName + " " + vendor.UserEntity.LastName;
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = vendor.TaxId != null ? vendor.TaxId : " ";
newVendor.TaxIdisEIN = vendor.TaxIdisEIN != null ? vendor.TaxIdisEIN : " ";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = vendor.Status;
newVendor.AddressVerifiedFlag = "Y";
//client vendors
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = vendor.Status;
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
//Get Vendor Admin Id
var GetVendorAdminId = db.Roles.Where(a => a.RoleName == "Vendor Admin" && a.ActiveFlag == "Y").FirstOrDefault();
if (GetVendorAdminId != null)
{
// Add data in VendorUser Table
VendorUser CU = new VendorUser();
CU.VendorUserId = Guid.NewGuid();
CU.Vendor = newVendor.VendorId;
CU.Role = GetVendorAdminId.RoleId;
CU.User = U.UserId;
CU.ActiveFlag = vendor.Status;
db.VendorUsers.Add(CU);
}
foreach (Guid value in vendor.ClientProblemClassId)
{
ClientVendorProblemClass CP = new ClientVendorProblemClass();
CP.ClientVendorProblemClassesId = Guid.NewGuid();
CP.ClientVendor = clientVendor.ClientVendorId;
CP.ProblemClass = value;
db.ClientVendorProblemClasses.Add(CP);
}
db.Vendors.Add(newVendor);
db.ClientVendors.Add(clientVendor);
if (db.SaveChanges() > 0)
{
UserID = U.UserId;
}
}
}
else
{
//we must need the vendor name
if (vendor.VendorName != null && vendor.VendorName.Trim().Length > 0)
{
#region No information entered by user for Vendor
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = vendor.VendorName != null ? vendor.VendorName : " ";
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = vendor.TaxId != null ? vendor.TaxId : " ";
newVendor.TaxIdisEIN = vendor.TaxIdisEIN != null ? vendor.TaxIdisEIN : " ";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = vendor.Status;
newVendor.AddressVerifiedFlag = "Y";
//client vendors
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = vendor.Status;
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
foreach (Guid value in vendor.ClientProblemClassId)
{
ClientVendorProblemClass CP = new ClientVendorProblemClass();
CP.ClientVendorProblemClassesId = Guid.NewGuid();
CP.ClientVendor = clientVendor.ClientVendorId;
CP.ProblemClass = value;
db.ClientVendorProblemClasses.Add(CP);
}
db.Vendors.Add(newVendor);
db.ClientVendors.Add(clientVendor);
if (db.SaveChanges() > 0)
{
UserID = newVendor.VendorId;
}
#endregion
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
public int UpdateVendor(VendorEntities vendor)
{
int result = 0;
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var GetVendorDetails = db.Vendors.Where(p => p.Email.ToLower().Trim() == vendor.Email.Trim().ToLower()).FirstOrDefault();
if (GetVendorDetails != null)
{
GetVendorDetails.VendorName = vendor.VendorName;
GetVendorDetails.Address01 = vendor.Address01;
GetVendorDetails.Address02 = vendor.Address02;
GetVendorDetails.City = vendor.City;
GetVendorDetails.State = vendor.State;
GetVendorDetails.Zip01 = vendor.Zip01;
GetVendorDetails.Zip02 = vendor.Zip02;
GetVendorDetails.Email = vendor.Email;
GetVendorDetails.TaxId = vendor.TaxId;
GetVendorDetails.TaxIdisEIN = vendor.TaxIdisEIN;
GetVendorDetails.Telephone = vendor.Telephone;
GetVendorDetails.ActiveFlag = vendor.Status;
//get client vendor info
var getclientvendors = db.ClientVendors.Where(p => p.Vendor == GetVendorDetails.VendorId &&
p.Client.ToString().Trim().ToLower() == vendor.ClientID.ToString().Trim().ToLower()).FirstOrDefault();
if (getclientvendors != null)
{
getclientvendors.ActiveFlag = vendor.Status;
getclientvendors.TaxDocument = vendor.TaxDocument;
getclientvendors.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
getclientvendors.FileType = cgFileTyle.CGSFileTypesId;
}
var VendorUser = db.VendorUsers.Where(x => x.Vendor == GetVendorDetails.VendorId).FirstOrDefault();
if (VendorUser != null)
{
VendorUser.ActiveFlag = vendor.Status;
}
// Delete all records in ClientVendorProblemClasses table
var allRec = db.ClientVendorProblemClasses.Where(a => a.ClientVendor == getclientvendors.ClientVendorId);
db.ClientVendorProblemClasses.RemoveRange(allRec);
db.SaveChanges();
// Insert new records in ClientVendorProblemClasses table
foreach (Guid value in vendor.ClientProblemClassId)
{
ClientVendorProblemClass CP = new ClientVendorProblemClass();
CP.ClientVendorProblemClassesId = Guid.NewGuid();
CP.ClientVendor = getclientvendors.ClientVendorId;
CP.ProblemClass = value;
db.ClientVendorProblemClasses.Add(CP);
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
}
}
return(result);
}
