public Int64 Save(string size)
{
int Value = 0;
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TyreSizeMaster tyreSize = db.TyreSizeMasters.Where(c => c.TyreSize == size).FirstOrDefault();
if (tyreSize == null)
{
TyreSizeMaster tbl = new TyreSizeMaster();
tbl.TyreSize = size;
tbl.Date_Added = System.DateTime.Now;
db.TyreSizeMasters.AddObject(tbl);
db.SaveChanges();
Value = 1;
Tran.Complete();
}
else
{
Value = -1;
}
}
}
catch (Exception ex)
{
Value = 0;
}
}
return(Value);
}
public Int64 Update(Int64 TyresizeIdno, string Size)
{
int Value = 0;
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TyreSizeMaster tyreSize = db.TyreSizeMasters.Where(c => c.TyreSize == Size && c.TyreSize_Idno != TyresizeIdno).FirstOrDefault();
if (tyreSize == null)
{
TyreSizeMaster tbl = db.TyreSizeMasters.Where(c => c.TyreSize_Idno == TyresizeIdno).FirstOrDefault();
tbl.TyreSize = Size;
tbl.Date_Modified = System.DateTime.Now;
db.SaveChanges();
Value = 1;
Tran.Complete();
}
else
{
Value = -1;
}
}
}
catch (Exception ex)
{
Value = 0;
}
}
return(Value);
}
public TyreSizeMaster SelectByID(Int64 TyresizeId)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TyreSizeMaster tbl = db.TyreSizeMasters.Where(t => t.TyreSize_Idno == TyresizeId).FirstOrDefault();
return(tbl);
}
}
public Int64 Delete(Int64 TyresizeId)
{
int Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TyreSizeMaster tbl = db.TyreSizeMasters.Where(t => t.TyreSize_Idno == TyresizeId).FirstOrDefault();
db.TyreSizeMasters.DeleteObject(tbl);
db.SaveChanges();
Value = 1;
}
}
catch (Exception ex)
{
Value = 0;
}
return(Value);
}
