public Results<string> creatSoftReq(softwareInfo rn,upgrade up)
{
Results<string> result = new Results<string>();
try
{
HelperData h = new HelperData();
rn.userCode = Convert.ToInt16(System.Web.HttpContext.Current.Session["userCode"]);
rn.deleted = false;
up.deleted = false;
Int16 t = h.AddSoftwareInfo(rn);
if (t != 0)
{
result.IsSuccessfull = true;
up.softwareCode = rn.softwareCode;
h.AddUpgrade(up);
}
}
catch (Exception error)
{
result.IsSuccessfull = false;
result.Message = error.Message;
}
return result;
}
public static string updateSoftReq(softwareInfo rn)
{
AddSoftwareBLL asb = new AddSoftwareBLL();
return JsonConvert.SerializeObject(asb.updateSoftReq(rn));
}
public static string creatSoftUpgradeReq(softwareInfo rn,upgrade up)
{
AddSoftwareBLL asb = new AddSoftwareBLL();
return JsonConvert.SerializeObject(asb.creatSoftReq(rn,up));
}
public softwareInfo Detailsoftware(Int16 softwareCode)
{
try{
var v = from i in db.softwareInfos
where i.softwareCode == softwareCode
select i;
softwareInfo newsoftware = v.FirstOrDefault();
return newsoftware;
}
catch (Exception error)
{
softwareInfo newsoft = new softwareInfo();
newsoft.softwareCode = -1;
return newsoft;
}
}
//Add To SoftwareInfo Table
public Int16 AddSoftwareInfo(softwareInfo si)
{
try
{
db.softwareInfos.InsertOnSubmit(si);
db.SubmitChanges();
return si.softwareCode;
}
catch (Exception error)
{
return 0;
}
}
//Edit SoftwareInfo Table
public int EditSoftwareInfo(softwareInfo si)
{
try
{
var v = from i in db.softwareInfos
where i.softwareCode == si.softwareCode
select i;
softwareInfo newsoftware = v.FirstOrDefault();
if(newsoftware != null)
{
newsoftware.softwareCode = si.softwareCode;
newsoftware.languageCode = si.languageCode;
newsoftware.memariCode = si.memariCode;
newsoftware.dbCode = si.dbCode;
newsoftware.cityInUse = si.cityInUse;
newsoftware.softwareName = si.softwareName;
newsoftware.serverLocation = si.serverLocation;
newsoftware.companyName = si.companyName;
newsoftware.softwarePrice = si.softwarePrice;
newsoftware.isSupport = si.isSupport;
newsoftware.endDateSupport = si.endDateSupport;
newsoftware.supportPrice = si.supportPrice;
newsoftware.isUsed = si.isUsed;
newsoftware.instalationDate = si.instalationDate;
newsoftware.contractNumber = si.contractNumber;
newsoftware.supportPeriodNumber = si.supportPeriodNumber;
newsoftware.supportPeriodType = si.supportPeriodType;
newsoftware.isHardwareLock = si.isHardwareLock;
newsoftware.isSource = si.isSource;
newsoftware.description = si.description;
newsoftware.lastDbVersion = si.lastDbVersion;
newsoftware.supervisorName = si.supervisorName;
newsoftware.supervisorTell = si.supervisorTell;
newsoftware.companyNamayandeName = si.companyNamayandeName;
newsoftware.supportTell = si.supportTell;
newsoftware.isReportCreate = si.isReportCreate;
newsoftware.isFixReport = si.isFixReport;
newsoftware.userCount = si.userCount;
newsoftware.isDocument = si.isDocument;
newsoftware.softwareProblem = si.softwareProblem;
newsoftware.isPatchUpdate = si.isPatchUpdate;
newsoftware.isFtpUpdate = si.isFtpUpdate;
newsoftware.isDirectAccessUpdate = si.isDirectAccessUpdate;
newsoftware.isOtherUpdate = si.isOtherUpdate;
newsoftware.isOpBuyer = si.isOpBuyer;
newsoftware.userCode = si.userCode;
newsoftware.deleted = false;
newsoftware.vahedCode = si.vahedCode;
newsoftware.zoneCode = si.zoneCode;
newsoftware.isAllVahed = si.isAllVahed;
newsoftware.companyTell = si.companyTell;
newsoftware.companyAddress = si.companyAddress;
newsoftware.subject = si.subject;
db.SubmitChanges();
return 1;
} return 0;//not found
}
catch (Exception error)
{
return -1;
}
}
private void detach_softwareInfos(softwareInfo entity)
{
this.SendPropertyChanging();
entity.DB = null;
}
private void attach_softwareInfos(softwareInfo entity)
{
this.SendPropertyChanging();
entity.DB = this;
}
partial void DeletesoftwareInfo(softwareInfo instance);
partial void UpdatesoftwareInfo(softwareInfo instance);
partial void InsertsoftwareInfo(softwareInfo instance);
private void detach_softwareInfos(softwareInfo entity)
{
this.SendPropertyChanging();
entity.programLanguage = null;
}
//Add To SoftwareInfo Table
public Int16 AddSoftwareInfo(softwareInfo si)
{
try
{
db.softwareInfos.InsertOnSubmit(si);
db.SubmitChanges();
if (si.vahedCode != 0)
{
si.softCodeDefine = (si.vahedCode).ToString() + (si.zoneCode).ToString() + (si.softwareCode).ToString();
}
else
si.softCodeDefine = "0" + (si.zoneCode).ToString() + (si.softwareCode).ToString();
return si.softwareCode;
}
catch (Exception error)
{
return 0;
}
}
public object updateSoftReq(softwareInfo rn)
{
Results<string> result = new Results<string>();
try
{
HelperData h = new HelperData();
rn.deleted = false;
rn.userCode = Convert.ToInt16(System.Web.HttpContext.Current.Session["userCode"]);
int t = h.EditSoftwareInfo(rn);
if (t != 0)
{
result.IsSuccessfull = true;
// result.Value = rn.softwareCode.ToString();
}
}
catch (Exception error)
{
result.IsSuccessfull = false;
result.Message = error.Message;
}
return result;
}
