public bool UpdateCity(CityDTO obj)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
using (var dbContextTransaction = DB.Database.BeginTransaction())
{
try
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
if (obj == null)
{
throw new ArgumentNullException("item");
}
DB.InsertCity(obj.CID, obj.CountryID, obj.CityName);
DB.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
}
}
public DocDTO AddDoc(DocDTO obj)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
using (var dbContextTransaction = DB.Database.BeginTransaction())
{
try
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
if (obj == null)
{
throw new ArgumentNullException("item");
}
// DB.Sp_InsertUpdateDoc(0,obj.EmpNo,obj.DocName);
//obj.ResultID = Convert.ToString(OutputParamValue.Value);
DB.SaveChanges();
dbContextTransaction.Commit();
return(obj);
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
}
}
public EmpDTO SaveEmployee(EmpDTO obj)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
using (var dbContextTransaction = DB.Database.BeginTransaction())
{
try
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
if (obj == null)
{
throw new ArgumentNullException("item");
}
DB.InsertEmployee(0, obj.EmpName, obj.Salary, obj.DeptName, obj.Designation, obj.EmpFile, obj.UserName, obj.Password, OutputParamValue);
obj.ResultID = Convert.ToString(OutputParamValue.Value);
DB.SaveChanges();
dbContextTransaction.Commit();
return(obj);
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
}
}
public void GetEmployeeListData()
{
DeveloperEntities db = new DeveloperEntities();
var EmpData = db.Employees.Where(p => p.IsActive == 1).OrderBy(s => s.EmpName).ToList();
if (EmpData != null)
{
ViewData["EmpData"] = EmpData;
}
}
public IEnumerable <CountryDTO> ConvertObjectToData(int id)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
var Result = from result in DB.GetAllCountry(id).ToList()
select new CountryDTO
{
CountryName = result.CountryName,
CID = result.CID
};
return(Result);
}
}
public CityDTO Get(int id)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var CityData = ConvertObjectToData(id);
if (CityData != null)
{
ObjCityDTO.CityEdit = CityData.Single();
return(CityData.Single());
}
return(null);
}
}
public IEnumerable <CityDTO> GetAll()
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var CityData = ConvertObjectToData(0);
if (CityData != null)
{
ObjCityDTO.CityGrid = CityData;
return(CityData);
}
return(null);
}
}
public Product_DTO Get(string ProIDStr)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var ProductData = ConvertProjectsObjectData(ProIDStr);
if (ProductData != null && ProductData.Count() > 0)
{
ObjProductDTO.ProductEdit = ProductData.Single();
return(ProductData.SingleOrDefault());
}
return(null);
}
}
public IEnumerable <Product_DTO> GetAll()
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var AllProductData = ConvertProjectsObjectData("");
if (AllProductData != null)
{
ObjProductDTO.ProductGrid = AllProductData;
return(AllProductData);
}
return(null);
}
}
public IEnumerable <Product_DTO> ConvertProjectsObjectData(string ProIDStr)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
var Result = from result in DB.SP_GetProduct(ProIDStr).ToList()
select new Product_DTO
{
ProID = result.ProID.ToString(),
ProName = result.ProName,
ProExpDate = result.ProEpxDate
};
return(Result);
}
}
public EmpDTO Get(int id)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var EmpData = ConvertObjectToData(id);
if (EmpData != null)
{
// objCnty.CountryEdit = CountryData.Single();
return(EmpData.Single());
}
return(null);
}
}
public IEnumerable <EmpDTO> GetAll()
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var EmpData = ConvertObjectToData(0);
if (EmpData != null)
{
//objCnty.CountryGrid = CountryData;
return(EmpData);
}
return(null);
}
}
public Product_DTO Add(Product_DTO product)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
if (product == null)
{
throw new ArgumentNullException("item");
}
DB.Sp_InsertUpdateProduct("", product.ProName, product.ProExpDate, 1);
DB.SaveChanges();
// product.ProID = Convert.ToInt32(OutputParamValue.Value);
return(product);
}
}
public static List <SelectListItem> GetCityMst()
{
List <SelectListItem> lst = new List <SelectListItem>();
DeveloperEntities db = new DeveloperEntities();
List <CityMaster> lst1 = db.CityMasters.Where(p => p.IsActive == 1).OrderBy(Q => Q.CityName).ToList();
lst.Add(new SelectListItem {
Text = "[Select]", Value = "-9"
});
foreach (var item in lst1)
{
lst.Add(new SelectListItem {
Text = item.CityName, Value = item.CID.ToString()
});
}
return(lst);
}
public IEnumerable <Product_DTO> SearchProduct(string search)
{
if (search == "null")
{
return(GetAll());
}
else
{
using (DeveloperEntities DB = new DeveloperEntities())
{
DB.Configuration.ProxyCreationEnabled = false;
DB.Configuration.LazyLoadingEnabled = false;
var SearchData = from result in ConvertProjectsObjectData("").ToList()
where result.ProName.StartsWith(search, StringComparison.OrdinalIgnoreCase) || result.ProName.Contains(search)
select result;
return(SearchData);
}
}
}
public IEnumerable <EmpDTO> ConvertObjectToData(int id)
{
using (DeveloperEntities DB = new DeveloperEntities())
{
var Result = from result in DB.GetEmpDetails("").ToList()
select new EmpDTO
{
EmpNo = result.EmpNo,
EmpName = result.EmpName,
Salary = result.Salary,
DeptName = result.DeptName,
Designation = result.Designation,
// UserName=result.Username,
// Password = result.Password
};
return(Result);
}
}
