public void Insert(GoodiesGroup entity)
{
try
{
if (entity.ID == Guid.Empty)
{
entity.ID = Guid.NewGuid();
}
this.Table.Add(entity);
this.SubmitChanges();
}
catch
{
throw;
}
}
public void Save(GoodiesGroup entity)
{
try
{
if (entity.ID == Guid.Empty)
{
entity.ID = Guid.NewGuid();
this.Insert(entity);
}
else
{
this.SubmitChanges();
}
}
catch
{
throw;
}
}
public void Delete(GoodiesGroup entity)
{
try
{
if (entity == null)
{
return;
}
if (this.HasChild(entity))
{
throw new Exception(Localize.ex_invalid_delete_operation);
}
this.Table.Remove(entity);
this.SubmitChanges();
}
catch
{
throw;
}
}
public void add_to_table_GoodiesGroup()
{
string[] excel_col_names = { "گروه اصلی", "گروه فرعی", "کالا", "کد گروه اصلی", "کد گروه فرعی", "کد کالا" };
// barresi vojode grouhe asli va grouhe fari dar excel
string[] gcn = getExcelColumns().Split(',');
int item_count = 0;
int col_count = 6;
string[] get_content = new string[col_count];
foreach (var item in gcn)
{
if (item == "گروه اصلی" || item == "گروه فرعی" || item == "کالا" || item == "کد گروه اصلی" || item == "کد گروه فرعی" || item == "کد کالا") //check kardane sar sotonha dar excel
{
item_count++;
}
}
// barresi vojode grouhe asli va grouhe fari excel dar DataBase
//string g = (string)(range.Cells[1, 2] as Excel1.Range).Value2.ToString();
//MessageBox.Show(range.Rows.Count.ToString());
// make log array
string [] log_array = new string[range.Rows.Count - 1];
for (int handle_rows_idx = 2, log_array_idx = 0; handle_rows_idx <= range.Rows.Count; handle_rows_idx++, log_array_idx++)
{
if (item_count == col_count)
{
//check for grouh asli
// check excel col validation
//..
//..
//..
//..
for (int handle_i = 0, j = 0; handle_i <= col_count - 1; handle_i++)
{
for (int i = 1; i <= col_count; i++)
{
string get_header = (string)(range.Cells[1, i] as Excel1.Range).Value2.ToString();
if (get_header == excel_col_names[handle_i])
{
switch (get_header)
{
case "گروه اصلی":
get_content[0] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
case "گروه فرعی":
get_content[1] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
case "کالا":
get_content[2] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
case "کد گروه اصلی":
get_content[3] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
case "کد گروه فرعی":
get_content[4] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
case "کد کالا":
get_content[5] = get_content[j] = (string)(range.Cells[handle_rows_idx, i] as Excel1.Range).Value2.ToString();
break;
}
j++;
break;
}
}
}
// check names in data base
string get_grouhe_asli_unique_path;
string get_grouhe_fari_unique_path;
string ga = get_content[0]; // grouhe asli
string gf = get_content[1]; // grouhe fari
//
// 1 - groh asli ...
bool grouhe_asli_exist = ak.GoodiesGroups.Any(i => i.CName == ga && i.CodeTitleId == code_grouhe_asli);
// gereftane grohefari marbootbe grouhe asli
// LOG ...
log_array[log_array_idx] = get_content[0] + "," + get_content[1] + "," + get_content[2];
//
if (grouhe_asli_exist)
{
get_grouhe_asli_unique_path = ak.GoodiesGroups.FirstOrDefault(i => i.CName == ga && i.CodeTitleId == code_grouhe_asli
).ID.ToString(); // gereftane code grouhe asli
//
bool grouhe_fari_marbot_be_asli = ak.GoodiesGroups.Any(i => i.CName == gf && i.CodeTitleId ==
code_grouhe_fari &&
i.uniquepath.Contains(get_grouhe_asli_unique_path) // grouh haye fari
);
if (grouhe_fari_marbot_be_asli)
{
var get_all_grohe_fari_marbot_be_1_grouhe_asli = ak.GoodiesGroups.Where(/*i => i.CName == gf &&*/ i => i.CodeTitleId ==
code_grouhe_fari &&
i.uniquepath.Contains(get_grouhe_asli_unique_path) // hame grouhaye fari asli
).ToList();
bool is_gouhe_fari_grouhe_asli_exist = false;
foreach (var get_grouhe_fari in get_all_grohe_fari_marbot_be_1_grouhe_asli)
{
if (get_grouhe_fari.CName == gf) // grouhe fari peyda shod
{
is_gouhe_fari_grouhe_asli_exist = true;
// gereftane grouhe_fari_unique path
get_grouhe_fari_unique_path = ak.GoodiesGroups.FirstOrDefault(i => i.CName == gf && i.CodeTitleId ==
code_grouhe_fari && i.uniquepath.Contains(get_grouhe_asli_unique_path)).uniquepath;
// id grouhe fari
Guid id_grouh_fari = ak.GoodiesGroups.FirstOrDefault(i => i.CName == gf && i.CodeTitleId ==
code_grouhe_fari && i.uniquepath.Contains(get_grouhe_asli_unique_path)).ID;
// MessageBox.Show(get_grouhe_fari_unique_path);
// unique pathe grouhe fari
// check for code kala
// gereftane kalahaye marboot be grohe asli va fari
// get all kala
var get__kala = ak.GoodiesGroups.Where(i => i.CodeTitleId == code_kala &&
i.uniquepath.StartsWith(get_grouhe_fari_unique_path));
bool kala_exist = false;
foreach (var item_ in get__kala)
{
if ("0" + get_content[5] == item_.Code)
{
kala_exist = true;
}
}
if (kala_exist == false)
{
Guid gfid = Guid.NewGuid();
GoodiesGroup gg = new GoodiesGroup();
gg.ID = gfid;
gg.Code = "0" + get_content[5];
gg.CName = get_content[2];
gg.ParentId = id_grouh_fari;
gg.uniquepath = get_grouhe_fari_unique_path + "#" + gfid;
gg.CodeTitleId = code_kala;
ak.GoodiesGroups.Add(gg);
int i = ak.SaveChanges();
if (i == 1)
{
// MessageBox.Show("با موفقیت ثبت شد");
log_array[log_array_idx] += "," + "کالا ثبت گردید";
}
break;
}
else
{
// MessageBox.Show("کالای مورد نظر وجود دارد");
log_array[log_array_idx] += "," + "کالا قبلا ثبت گردیده است";
break;
}
} // if
} // foreach
} // if
else
{
log_array[log_array_idx] += "," + "گروه فرعی وجود ندارد";
}
} // if
else
{
log_array[log_array_idx] += "," + "گروه اصلی وجود ندارد";
}
// 2 - groh fari
bool grouhe_fari_exist = ak.GoodiesGroups.Any(i => i.CName == gf && i.CodeTitleId == code_grouhe_fari);
} // if
else /* file has error */ } {
} // for
frm_MessageLog frm_messageLog = new frm_MessageLog(log_array);
frm_messageLog.WindowStartupLocation = WindowStartupLocation.CenterScreen;
frm_messageLog.ShowDialog();
}
