public static MethodReturn RepairDepoRaf(SERVISDEPOLAR depo, string strRaf, decimal servisId)
{
MethodReturn ret = new MethodReturn();
if (depo == null)
{
return(ret);
}
if (strRaf.isNullOrWhiteSpace())
{
strRaf = "1.Raf";
}
SERVISDEPORAFLAR foundRaf = R.Query <SERVISDEPORAFLAR>(ret).First(t => t.SERVISDEPOID == depo.ID && t.AD == strRaf).createIsNull();
if (ret.ok() && foundRaf.IsNew())
{
decimal seqId = Convert.ToDecimal(SasonBase.SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPORAFLAR_SEQ.NEXTVAL from dual", ret));
if (ret.ok())
{
foundRaf.ID = seqId;
foundRaf.KOD = strRaf;
foundRaf.AD = strRaf;
foundRaf.SERVISDEPOID = depo.ID;
foundRaf.DURUMID = 1;
ret = foundRaf.Update();
}
}
return(ret);
}
public static SERVISDEPOLAR CheckAndGetDefaultDepo(MethodReturn refMr, decimal servisId, string depoAdi = "")
{
refMr = refMr.createIsNull();
string writeDepoKodu = "001";
string writeDepoAdi = "Ana Depo";
SERVISDEPOLAR defaultDepo = null;
if (depoAdi.isNullOrWhiteSpace())
{
defaultDepo = Select.OrderBy(t => t.KOD).First(t => t.SERVISID == servisId);
}
else
{
writeDepoKodu = depoAdi;
writeDepoAdi = depoAdi;
defaultDepo = Select.First(t => t.AD == writeDepoAdi && t.SERVISID == servisId);
}
if (defaultDepo.isNull())
{
decimal seqId = Convert.ToDecimal(SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPOLAR_SEQ.NEXTVAL from dual", refMr));
if (refMr.ok())
{
defaultDepo = new SERVISDEPOLAR()
{
ID = seqId,
KOD = writeDepoKodu, // "001",
AD = writeDepoAdi, // "Ana Depo",
SERVISDEPOGRUPID = null,
DEPOTIPID = 0,
RAFSIZ = 0,
DURUMID = 1,
SERVISID = servisId,
};
refMr = defaultDepo.Update();
}
if (refMr.error())
{
defaultDepo = null;
}
}
return(defaultDepo);
}
public static SERVISDEPORAFLAR CreateRaf(SERVISDEPOLAR depo, string strRaf, decimal servisId, MethodReturn mr = null)
{
SERVISDEPORAFLAR foundRaf = R.Query <SERVISDEPORAFLAR>(mr).First(t => t.SERVISDEPOID == depo.ID && t.AD == strRaf).createIsNull();
if (mr.ok() && foundRaf.IsNew())
{
decimal seqId = Convert.ToDecimal(SasonBase.SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPORAFLAR_SEQ.NEXTVAL from dual", mr));
if (mr.ok())
{
foundRaf.ID = seqId;
foundRaf.KOD = strRaf;
foundRaf.AD = strRaf;
foundRaf.SERVISDEPOID = depo.ID;
foundRaf.DURUMID = 1;
mr = foundRaf.Update();
}
}
return(foundRaf);
}
