public StoreIn(SessionInfo _session = null, StoreInHead model = null)
{
InitializeComponent();
this._repoPlan = new StoreInPlanRepo();
this._repo = new StoreInRepo();
this._repoWhse = new WharehouseRepo();
//Initial Session and content
this.HeadContent = new StoreInHead();
epiSession = _session;
if (model != null) this.HeadContent = model;
this.ModelClone = new StoreInHead();
HeadContent.InsertState = false;
}
public StoreInHead InsertStoreIn(StoreInHead model, SessionInfo epiSession)
{
int id = 0;
id = GenerateId(epiSession.PlantID);
string sql = string.Format(@"IF NOT EXISTS
(
SELECT * FROM ucc_ic_StoreInHead (NOLOCK)
WHERE TransactionID = {13}
)
BEGIN
INSERT INTO ucc_ic_StoreInHead
(Company
,Plant
,TransactionType
,StoreInId
,StoreInNum
,StoreInPlanId
,StoreInDate
,PORateType
,PORate
,DutyRate
,Poscession
,ActiveFlag
,CreationDate
,LastUpdateDate
,CreatedBy
,UpdatedBy
,PONum
,PONumber)
VALUES
(N'{0}' --<Company, nvarchar(8),>
,N'{1}' --<Plant, nvarchar(8),>
,N'{2}' --<TransactionType, nvarchar(15),>
,{3} --<StoreInId, int,>
,N'{4}' --<StoreInNum, nvarchar(10),>
,{5} --<StoreInPlanId, int,>
,CONVERT(DATETIME, '{6}',103) --<StoreInDate, datetime,>
,N'{7}' --<PORateType, nvarchar(50),>
,{8} --<PORate, decimal(18,2),>
,{9} --<DutyRate, decimal(18,2),>
,{10} --<Poscession, nvarchar(50),>
,{11} --<ActiveFlag, tinyint,>
,GETDATE() --<CreationDate, datetime,>
,GETDATE() --<LastUpdateDate, datetime,>
,N'{12}' --<CreatedBy, varchar(45),>
,N'{12}' --<UpdatedBy, varchar(45),>
,N'{14}' --<CreatedBy, varchar(45),>
,N'{15}' --<UpdatedBy, varchar(45),>
)
END" + Environment.NewLine
, epiSession.CompanyID //{0}
, epiSession.PlantID
, model.PossessionPromt.ToUpper()
, id
, "IN" + id.ToString("00000")
, model.StoreInPlanId //{5}
, model.StoreInDate.ToString("dd/MM/yyyy hh:mm:ss")
, "" //Fix PORateType to string.Empty
, model.ExchangeRate
, model.ExchangeRate
, model.Possession //{10}
, 1
, epiSession.UserID
, model.TransactionID
, model.PONum
, model.PONumber);
Repository.Instance.ExecuteWithTransaction(sql, "Update Stock");
return GetStoreInByID(id, epiSession.PlantID);
}
private void jISHAZAIToolStripMenuItem_Click(object sender, EventArgs e)
{
ClearHeaderContent();
HeadContent = new StoreInHead();
HeadContent.StoreInFlag = "0";
HeadContent.Possession = 0; //Set Posession (JISHAZAI)
HeadContent.InsertState = true;
ModelClone = (StoreInHead)HeadContent.Clone();
SetHeaderContent(HeadContent);
button1.Enabled = true;
}
private void StoreIn_Load(object sender, EventArgs e)
{
if (epiSession.SessionID == null)
{
Login frm = new Login();
frm.ShowDialog();
}
else if (epiSession.SessionID == "x")
{
this.Dispose();
this.Close();
Environment.Exit(1);
}
else
{
this.Text = epiSession.PlantName;
if (HeadContent.StoreInPlanId != 0)
{
txtStoreInNum.Text = HeadContent.StoreInNum;
SetHeaderContent(HeadContent);
}
ModelClone = (StoreInHead)HeadContent.Clone();
return;
}
StoreIn_Load(sender, e);
}
private void tlbSave_Click(object sender, EventArgs e)
{
//bool IsSuccess;
string msg;
int StoreInid;
int SelectedCount = 0;
if (dataGridView1.Rows.Count == 0)
{
return;
}
if (!HashListSeleted())
{
MessageBox.Show("Please select rows in grid.", "Please try agian.", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
if (!HashArticleSelected(out SelectedCount))
{
MessageBox.Show("Please select rows in grid.", "Please try agian.", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
if (SelectedCount > 0)
{
DialogResult dialogResult = MessageBox.Show("Are you sure to save store in. \rAfter your save, you can't modify it.", "Please Confirm.", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int iRow = dataGridView1.CurrentRow.Index;
List<StoreInDetail> selectedList = new List<StoreInDetail>();
for (int i = 0; (this.dataGridView2.Rows.Count) > i; i++)
{
if ((bool)dataGridView2[0, i].EditedFormattedValue && string.IsNullOrEmpty(dataGridView2.Rows[i].Cells["stock"].Value.GetString()))
{
dataGridView2.CurrentCell = dataGridView2[0, i];
var item = new StoreInDetail();
item = _repo.GetArticleListToSave(Convert.ToInt32(dataGridView2.Rows[i].Cells["lineid"].Value));
item.Location = dataGridView2.Rows[i].Cells["Place"].Value.GetString();
item.NGStatus = Convert.ToInt32(dataGridView2.Rows[i].Cells["ngflag"].Value.GetBoolean());
item.NGRemark = dataGridView2.Rows[i].Cells["ngRemark"].Value.GetString();
HeadContent.PONum = item.PONum;
HeadContent.PONumber = item.PONumber;
selectedList.Add(item);
}
}
if (selectedList != null)
{
HeadContent.StoreInDate = DateTime.Now;
HeadContent = _repo.InsertStoreIn(HeadContent, epiSession);
_repo.InsertStoreInLine(selectedList, epiSession, HeadContent.StoreInID, HeadContent.TransactionID, out msg);
}
SetHeaderContent(HeadContent);
MessageBox.Show("Save Store In completed. And then will be create Part in Epicor.", "Progression.", MessageBoxButtons.OK);
Progression frm1 = new Progression("NEWPART", HeadContent.TransactionID, epiSession, HeadContent.Possession);
frm1.ShowDialog();
tlbSave.Enabled = false;
SetHeaderContent(HeadContent, true);
var result = _repo.GetDetailArticle(HeadContent.StoreInPlanId, HeadContent.TransactionID);
SetDetailArticle(result, true);
}
}
}
private void tlbClear_Click(object sender, EventArgs e)
{
ClearHeaderContent();
HeadContent = new StoreInHead();
HeadContent.InsertState = false;
HeadContent.StoreInFlag = "0";
HeadContent.Possession = 3;
ModelClone = (StoreInHead)HeadContent.Clone();
SetHeaderContent(HeadContent);
//button1.Enabled = true;
}
private void SetHeaderContent(StoreInHead model, bool saved = false)
{
ClearHeaderContent();
txtStoreInNum.DataBindings.Add("Text", model, "StoreInNum", false, DataSourceUpdateMode.OnPropertyChanged);
txtStoreInPlanNum.DataBindings.Add("Text", model, "StoreInPlanNum", false, DataSourceUpdateMode.OnPropertyChanged);
txtInvoiceNum.DataBindings.Add("Text", model, "InvoiceNum", false, DataSourceUpdateMode.OnPropertyChanged);
txtSupplierCode.DataBindings.Add("Text", model, "SupplierCode", false, DataSourceUpdateMode.OnPropertyChanged);
txtSupplierName.DataBindings.Add("Text", model, "SupplierName", false, DataSourceUpdateMode.OnPropertyChanged);
txtMakerCode.DataBindings.Add("Text", model, "MakerCode", false, DataSourceUpdateMode.OnPropertyChanged);
txtMakerName.DataBindings.Add("Text", model, "MakerName", false, DataSourceUpdateMode.OnPropertyChanged);
txtMillCode.DataBindings.Add("Text", model, "MillCode", false, DataSourceUpdateMode.OnPropertyChanged);
txtMillName.DataBindings.Add("Text", model, "MillName", false, DataSourceUpdateMode.OnPropertyChanged);
txtBussinessType.DataBindings.Add("Text", model, "BussinessType", false, DataSourceUpdateMode.OnPropertyChanged);
txtBussinessTypeName.DataBindings.Add("Text", model, "BussinessTypeName", false, DataSourceUpdateMode.OnPropertyChanged);
txtVessel.DataBindings.Add("Text", model, "Vessel", false, DataSourceUpdateMode.OnPropertyChanged);
txtLoadPort.DataBindings.Add("Text", model, "LoadPort", false, DataSourceUpdateMode.OnPropertyChanged);
txtArivePort.DataBindings.Add("Text", model, "ArivePort", false, DataSourceUpdateMode.OnPropertyChanged);
txtETADate.DataBindings.Add("Text", model, "ETADate", false, DataSourceUpdateMode.OnPropertyChanged);
txtETDDate.DataBindings.Add("Text", model, "ETDDate", false, DataSourceUpdateMode.OnPropertyChanged);
txtInvoiceDate.DataBindings.Add("Text", model, "InvoiceDate", false, DataSourceUpdateMode.OnPropertyChanged);
//if (HeadContent.Possession != 2)
//{
txtPoscession.DataBindings.Add("Text", model, "PossessionPromt", false, DataSourceUpdateMode.OnPropertyChanged);
//}
if (HeadContent.InsertState == true)
{
button1.Enabled = true;
}
else
{
button1.Enabled = false;
}
if (model.StoreInFlag == "1")
{
tlbSave.Enabled = false;
}
else
{
tlbSave.Enabled = true;
}
//If not yet saving Store In.
if (!saved)
{
var result = _repo.GetDetail(HeadContent.StoreInPlanId);
SetDetail(result);
}
else
{
var result = _repo.GetDetailByStoreIn(HeadContent.StoreInID);
SetDetail(result);
}
}