public static bool SavePrintOrder(Datasource.dsQry.XRepCard1DataTable PrintTbl)
{
bool output = false;
SqlConnection con = new SqlConnection(Properties.Settings.Default.E_CardConnectionString);
SqlCommand cmd = new SqlCommand("INSERT INTO TBLPrintOut (DataId, printdate, datein, userin) VALUES (@DataId, GETDATE(), GETDATE(), @userin)", con);
SqlParameter PramDataId = new SqlParameter("@DataId", SqlDbType.Int);
SqlParameter Pramuserin = new SqlParameter("@userin", SqlDbType.Int)
{
Value = UserManager.UserInfo.UserID
};
cmd.Parameters.Add(PramDataId);
cmd.Parameters.Add(Pramuserin);
try
{
con.Open();
foreach (Datasource.dsQry.XRepCard1Row row in PrintTbl.Rows)
{
PramDataId.Value = row.DataId;
cmd.ExecuteNonQuery();
}
output = true;
}
catch (SqlException ex)
{
Logger.Error(ex.Message, ex);
System.Windows.Forms.MessageBox.Show(ex.Message, "Error While Saving Printing Order", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
con.Close();
return(output);
}
private void lueCardLayout_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph)
{
return;
}
if (FXFW.SqlDB.IsNullOrEmpty(lueTBLALLData.EditValue))
{
MsgDlg.Show("يجب اختيار من القائمة", MsgDlg.MessageType.Error);
return;
}
Datasource.dsQry.XRepCard1DataTable PrintTbl = new Datasource.dsQry.XRepCard1DataTable();
for (int i = 0; i < gridViewMain.SelectedRowsCount; i++)
{
PrintTbl.Rows.Add(gridViewMain.GetDataRow(gridViewMain.GetSelectedRows()[i]).ItemArray);
}
switch (lueCardLayout.SelectedIndex)
{
case 0: //Card 1
ECard.Forms.XRep.XRepCard1 FrmRep1 = new ECard.Forms.XRep.XRepCard1(PrintTbl);
ECard.Classes.Misc.ShowPrintPreview(FrmRep1, true);
break;
case 1: //Card 2
ECard.Forms.XRep.XRepCard2 FrmRep2 = new ECard.Forms.XRep.XRepCard2(PrintTbl);
ECard.Classes.Misc.ShowPrintPreview(FrmRep2, true);
break;
case 2: //Card 3
ECard.Forms.XRep.XRepCard3 FrmRep3 = new ECard.Forms.XRep.XRepCard3(PrintTbl);
ECard.Classes.Misc.ShowPrintPreview(FrmRep3, true);
break;
case 3: //Card 4
ECard.Forms.XRep.XRepCard4 FrmRep4 = new ECard.Forms.XRep.XRepCard4(PrintTbl);
ECard.Classes.Misc.ShowPrintPreview(FrmRep4, true);
break;
default:
break;
}
//Saving Printing Order
if (MsgDlg.Show("هل تريد حقظ الطباعة؟", MsgDlg.MessageType.Question) == DialogResult.Yes)
{
if (!Classes.Managers.DataManager.SavePrintOrder(PrintTbl))
{
MsgDlg.Show("لم يتم الحفظ", MsgDlg.MessageType.Error);
return;
}
}
}
