public static bool AddCustomer(Customer obj, bool isInsert)
{
bool status = false;
if (obj != null)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
if (isInsert)
{
obj.CreatedOn = DateTime.Now;
db.Customers.InsertOnSubmit(obj);
status = true;
}
else
{
Customer dbobj = db.Customers.Where(x => x.CustomerID == obj.CustomerID).SingleOrDefault();
if (dbobj != null)
{
dbobj.Name = obj.Name;
dbobj.Address = obj.Address;
dbobj.Gender = obj.Gender;
dbobj.ModifiedOn = DateTime.Now;
status = true;
}
}
db.SubmitChanges();
}
return(status);
}
public static bool InsertUserDetails(UserDetail obj, bool IsInsert)
{
bool status = false;
if (obj != null)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
if (IsInsert)
{
obj.CreatedOn = DateTime.Now;
db.UserDetails.InsertOnSubmit(obj);
}
else
{
UserDetail dbobj = db.UserDetails.Where(x => x.UserID == obj.UserID).SingleOrDefault();
if (dbobj != null)
{
dbobj.FullName = obj.FullName;
dbobj.UserName = obj.UserName;
dbobj.UserType = obj.UserType;
dbobj.PasswordAsHash = obj.PasswordAsHash;
}
}
db.SubmitChanges();
status = true;
}
return(status);
}
public static void DeleteCustomerDetail(int customerId)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
Customer obj = db.Customers.Where(x => x.CustomerID == customerId).SingleOrDefault();
db.Customers.DeleteOnSubmit(obj);
db.SubmitChanges();
}
public static void DeleteItemDetails(Guid itemId)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
ItemOrProduct obj = db.ItemOrProducts.Where(x => x.ItemID == itemId).SingleOrDefault();
db.ItemOrProducts.DeleteOnSubmit(obj);
db.SubmitChanges();
}
public static void DeleteUserTypeDetail(int usertypeId)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
UserType obj = db.UserTypes.Where(x => x.UserTypeID == usertypeId).SingleOrDefault();
db.UserTypes.DeleteOnSubmit(obj);
db.SubmitChanges();
}
public static bool AddItem(ItemOrProduct obj)
{
bool status = false;
if (obj != null)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
obj.CreatedOn = DateTime.Now;
db.ItemOrProducts.InsertOnSubmit(obj);
db.SubmitChanges();
status = true;
}
return(status);
}
public static bool EditItem(ItemOrProduct obj)
{
bool status = false;
if (obj != null)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
ItemOrProduct dbobj = db.ItemOrProducts.Where(x => x.ItemID == obj.ItemID).SingleOrDefault();
if (dbobj != null)
{
dbobj.Name = obj.Name;
dbobj.PurchasePrice = obj.PurchasePrice;
dbobj.SalesPrice = obj.SalesPrice;
dbobj.OpeningQty = obj.OpeningQty;
dbobj.ModifiedOn = DateTime.Now;
}
db.SubmitChanges();
status = true;
}
return(status);
}
public static bool InsertUserTypeDetails(UserType obj, bool IsInsert)
{
bool status = false;
if (obj != null)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
if (IsInsert)
{
db.UserTypes.InsertOnSubmit(obj);
}
else
{
UserType dbobj = db.UserTypes.Where(x => x.UserTypeID == obj.UserTypeID).SingleOrDefault();
if (dbobj != null)
{
dbobj.UserType1 = obj.UserType1;
}
}
db.SubmitChanges();
status = true;
}
return(status);
}
public static Customer GetCustomerByID(int customerID)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.Customers.Where(x => x.CustomerID == customerID).SingleOrDefault());
}
public static List <Customer> GetAllCustomerDetails()
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.Customers.ToList());
}
public static ItemOrProduct GetItemByID(Guid itemID)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.ItemOrProducts.Where(x => x.ItemID == itemID).SingleOrDefault());
}
public static List <ItemOrProduct> GetAllItemDetails()
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.ItemOrProducts.ToList());
}
public static List <UserType> GetAllUserTypeDetails()
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.UserTypes.ToList());
}
public static UserType GetUserTypeByID(int usertypeID)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.UserTypes.Where(x => x.UserTypeID == usertypeID).SingleOrDefault());
}
public static UserDetail GetUserByID(Guid userID)
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.UserDetails.Where(x => x.UserID == userID).SingleOrDefault());
}
public static List <GetUserDetailsResult> GetAllUserDetails()
{
DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext();
return(db.GetUserDetails().ToList());
}
