public tCycleCountHead GetCyleCountHeadByID(long CycleHeadID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
tCycleCountHead HeadCycle = new tCycleCountHead();
HeadCycle = (from p in ce.tCycleCountHeads
where p.ID == CycleHeadID
select p).FirstOrDefault();
return(HeadCycle);
}
protected void GetCyleCountHeadByID(long CycleheadID)
{
iCycleCountClient cycle = new iCycleCountClient();
CustomProfile profile = CustomProfile.GetProfile();
tCycleCountHead Cyclehead = new tCycleCountHead();
Cyclehead = cycle.GetCyleCountHeadByID(CycleheadID, profile.DBConnection._constr);
if (Cyclehead.Title != null)
{
txtTitle.Text = Cyclehead.Title.ToString();
}
FillWarehouse();
if (Cyclehead.WarehouseID != null)
{
ddlWarehouse.SelectedIndex = ddlWarehouse.Items.IndexOf(ddlWarehouse.Items.FindByValue(Cyclehead.WarehouseID.ToString()));
}
hdnwarehouseId.Value = Cyclehead.WarehouseID.ToString();
if (Cyclehead.CycleCountDate != null)
{
UC_FromDate.Date = Cyclehead.CycleCountDate;
}
if (Cyclehead.Exicutive != null)
{
txtexicutive.Text = Cyclehead.Exicutive.ToString();
}
if (Cyclehead.Status != null)
{
ddlstatus.SelectedIndex = ddlstatus.Items.IndexOf(ddlstatus.Items.FindByText(Cyclehead.Status.ToString()));
}
if (Cyclehead.CountBasis != null)
{
ddlcountbasis.SelectedIndex = ddlcountbasis.Items.IndexOf(ddlcountbasis.Items.FindByText(Cyclehead.CountBasis.ToString()));
}
if (Cyclehead.Frequency != null)
{
hdnfrequency.Value = Cyclehead.Frequency.ToString();
}
if (Cyclehead.Active == "Yes")
{
rbtnActiveYes.Checked = true;
rbtnActiveNo.Checked = false;
}
else
{
rbtnActiveYes.Checked = false;
rbtnActiveNo.Checked = true;
}
}
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
CustomProfile profile = CustomProfile.GetProfile();
iCycleCountClient cycleclient = new iCycleCountClient();
tCycleCountHead cycleH = new tCycleCountHead();
DataSet ds = new DataSet();
if (hdnCycleheadID.Value != "")
{
cycleH.ID = long.Parse(hdnCycleheadID.Value);
cycleH.Title = txtTitle.Text.ToString();
cycleH.Status = ddlstatus.SelectedItem.Text;
cycleH.CountBasis = ddlcountbasis.SelectedItem.Text;
cycleH.CycleCountDate = UC_FromDate.Date;
cycleH.WarehouseID = long.Parse(hdnwarehouseId.Value);
cycleH.Frequency = hdnfrequency.Value;
cycleH.CreatedBy = profile.Personal.UserID;
cycleH.CreationDate = DateTime.Now;
cycleH.Active = "Yes";
if (rbtnActiveNo.Checked == true)
{
cycleH.Active = "No";
}
ds = cycleclient.getCompanyCustomer(long.Parse(hdnwarehouseId.Value), profile.DBConnection._constr);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cycleH.CompanyID = long.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString());
cycleH.CustomerID = long.Parse(ds.Tables[0].Rows[0]["CustomerID"].ToString());
}
long CycleHeadID = cycleclient.SaveCycleCountHead(cycleH, profile.DBConnection._constr);
WebMsgBox.MsgBox.Show("Record saved successfully");
clear();
BindCycleMainGrid();
Response.Redirect("CycleCount.aspx");
}
}
public long SaveCycleCountHead(tCycleCountHead CycleHead, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
try
{
if (CycleHead.ID == 0)
{
db.tCycleCountHeads.AddObject(CycleHead);
db.SaveChanges();
}
else
{
db.tCycleCountHeads.Attach(CycleHead);
db.ObjectStateManager.ChangeObjectState(CycleHead, EntityState.Modified);
db.SaveChanges();
}
return(CycleHead.ID);
}
catch
{
return(0);
}
}
public static string PMSaveWLocation(object Plans)
{
string result = "";
CustomProfile profile = CustomProfile.GetProfile();
iCycleCountClient cycleclient = new iCycleCountClient();
tCycleCountHead cycleH = new tCycleCountHead();
string ContBasis = "", SessionID = "";
try
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary = (Dictionary <string, object>)Plans;
cycleH.Title = dictionary["Title"].ToString();
cycleH.WarehouseID = long.Parse(dictionary["WarehouseID"].ToString());
cycleH.Status = dictionary["Status"].ToString();
cycleH.Frequency = dictionary["Frequency"].ToString();
string Frequency = dictionary["Frequency"].ToString();
cycleH.CountBasis = dictionary["CountBasis"].ToString();
cycleH.Active = "Yes";
ContBasis = dictionary["CountBasis"].ToString();
SessionID = dictionary["session"].ToString();
DateTime FromDate = DateTime.Parse(dictionary["FromDate"].ToString());
DateTime ToDate = DateTime.Parse(dictionary["ToDate"].ToString());
TimeSpan days = ToDate - FromDate;
long DaysNo = long.Parse(days.TotalDays.ToString());
long totaldays = 0;
int i = 0;
int j = 0;
int ival;
if (Frequency == "Daily")
{
if (DaysNo >= 12)
{
result = "More Than Daily";
}
else
{
totaldays = DaysNo;
}
}
else if (Frequency == "Weekly")
{
if (DaysNo >= 84)
{
result = "More Than Weekly";
}
else
{
double dayst = DaysNo / 7;
totaldays = long.Parse(Math.Round(dayst).ToString());
}
}
else if (Frequency == "Monthly")
{
if (DaysNo >= 365)
{
result = "More Than Monthly";
}
else
{
double dayst = DaysNo / 30;
}
}
else if (Frequency == "Quarterly")
{
if (DaysNo >= 1080)
{
result = "More Than Quarterly";
}
else
{
double dayst = DaysNo / 90;
totaldays = long.Parse(Math.Round(dayst).ToString());
}
}
if (result == "")
{
for (i = 0; i <= totaldays; i++)
{
cycleH.CycleCountDate = FromDate.AddDays(j);
long CycleHeadID = cycleclient.SaveCycleCountHead(cycleH, profile.DBConnection._constr);
BulkInsertToDataBase(ContBasis, CycleHeadID, SessionID);
if (Frequency == "Daily")
{
j = j + 1;
}
else if (Frequency == "Weekly")
{
j = j + 7;
}
else if (Frequency == "Monthly")
{
j = j + 30;
}
else if (Frequency == "Quarterly")
{
j = j + 90;
}
}
result = "Cycle saved successfully";
DeleteFromCycleTempData(ContBasis, SessionID);
}
}
catch
{
result = "Some error occurred";
DeleteFromCycleTempData(ContBasis, SessionID);
}
finally
{
cycleclient.Close();
}
return(result);
}
