//Operation Part
protected void Save_Click(object sender, EventArgs e)
{
TransportCommand TransCmd = TransportCommandModel();
if (TransCmd.Id == 0)
{
try
{
db.TransportCommand.Add(TransCmd);
db.SaveChanges();
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "تنبيه", "alert('تم الحفظ بنجاح')", true);
}
catch (Exception except)
{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "تنبيه", "alert('حدثت مشكلة لم يتم الحفظ')", true);
}
}
else
{
try
{
db.TransportCommand.AddOrUpdate(TransCmd);
db.SaveChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "تنبيه", "alert('تم الحفظ بنجاح')", true);
}
catch (Exception except)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "تنبيه", "alert('حدثت مشكلة لم يتم الحفظ')", true);
}
}
ClearModel();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
public Task <Tuple <TestResult, TransportCommand <TestCommand, TestMetadata, string> > > Handle(
TransportCommand <TestCommand, TestMetadata, string> cmd)
{
var testResult = new TestResult(cmd.Metadata.CorrelationId);
return(Task.FromResult(Tuple.Create(testResult, cmd)));
}
private Task HandleTransportCommand(TransportCommand command, CancellationToken cancellationToken)
{
return(command switch
{
TransportCommand.Open => OpenConnectionAsync(cancellationToken),
TransportCommand.Close => CloseConnectionAsync(cancellationToken),
_ => Task.CompletedTask,
});
protected void NewSearch_Click(object sender, EventArgs e)
{
SearchTransCmdList = new List <TransportCommand>();
ClearSearchModel();
TransCmdList = new List <TransportCommand>();
myTransCmd = new TransportCommand();
TransCmdList = db.TransportCommand.ToList();
BindGridList();
}
public Task <Tuple <TestResult, TransportCommand <TestOutCommand, TestMetadata, string> > > Handle(
TransportCommand <TestCommand, TestMetadata, string> cmd)
{
var testResult = new TestResult(cmd.Metadata.CorrelationId);
TestOutCommand nextDomainCmd = new TestOutCommand(cmd.DomainCommand.Id);
TransportCommand <TestOutCommand, TestMetadata, string> nextCmd =
new TransportCommand <TestOutCommand, TestMetadata, string>(nextDomainCmd, cmd.Metadata);
return(Task.FromResult(Tuple.Create(testResult, nextCmd)));
}
public Task <bool> AckTransportCommand(
TransportCommand <TestCommand, TestMetadata, string> cmd)
{
if (!_commands.ContainsKey(cmd.Metadata.CorrelationId))
{
return(Task.FromResult(false));
}
var x = _commands[cmd.Metadata.CorrelationId];
_commands[cmd.Metadata.CorrelationId] = Tuple.Create(x.Item1, true);
return(Task.FromResult(true));
}
public Task ForwardCommand(
TransportCommand <TCmd, TestMetadata, string> transportCommand)
{
TransportCommand <TCmd, TestMetadata, string> nextCmd = GetNext(transportCommand);
Option <string> nextRoute = nextCmd.Metadata.RoutingSlip.Head();
foreach (var route in nextRoute)
{
Forwarded = Tuple.Create(transportCommand, route);
}
return(Task.CompletedTask);
}
protected TransportCommand SearchModel()
{
TransportCommand TransCmd = new TransportCommand();
TransCmd.SubAccClientId = Convert.ToInt32(SubClientSearchListtxt.SelectedValue);
TransCmd.SubAccVendorId = Convert.ToInt32(SubVendorSearchListtxt.SelectedValue);
TransCmd.CarId = Convert.ToInt32(CarSearchListtxt.SelectedValue);
TransCmd.ProductId = ProductSearchListtxt.SelectedValue;
TransCmd.FromRegionId = Convert.ToInt32(FromRegionSearchListtxt.SelectedValue);
TransCmd.ToRegionId = Convert.ToInt32(ToRegionSearchListtxt.SelectedValue);
TransCmd.TransportType = TransTypeSearchListtxt.SelectedValue;
TransCmd.PaymentWay = PayMethSearchListtxt.SelectedValue;
return(TransCmd);
}
protected void edit_Command(object sender, CommandEventArgs e)
{
TransportCommand EditTransCmd = new TransportCommand();
int index = Convert.ToInt32(e.CommandArgument);
if (SearchTransCmdList.Count > 0)
{
EditTransCmd = SearchTransCmdList[index];
}
else
{
EditTransCmd = TransCmdList[index];
}
try
{
TransCmdTxt.Text = EditTransCmd.Id.ToString();
TransCmdDate.Text = EditTransCmd.TransportCommandTime.ToString();
AddClientListhtml.SelectedValue = EditTransCmd.SubAccClientId.ToString();
AddVendorListhtml.SelectedValue = EditTransCmd.SubAccVendorId.ToString();
AddCarsListhtml.SelectedValue = EditTransCmd.CarId.ToString();
AddProductListhtml.SelectedValue = EditTransCmd.ProductId.ToString();
AddFromRegionListhtml.SelectedValue = EditTransCmd.FromRegionId.ToString();
AddRegionToListhtml.SelectedValue = EditTransCmd.ToRegionId.ToString();
TransportPrice.Text = EditTransCmd.TransportPrice.ToString();
Quantity.Text = EditTransCmd.Quantity.ToString();
AddTransportTypeListhtml.SelectedValue = EditTransCmd.TransportType.ToString();
TotalTransportPrice.Text = EditTransCmd.TotalTransportPrice.ToString();
AddPaymentMethodListhtml.SelectedValue = EditTransCmd.PaymentWay.ToString();
AtHour.Text = EditTransCmd.TimeOfShipping.ToString();
}
catch (Exception Exec)
{
}
SearchTransCmdList = new List <TransportCommand>();
UpdatePanel3.Update();
}
// Searching Part
protected void Search_Click(object sender, EventArgs e)
{
SearchTransCmdList = new List <TransportCommand>();
TransCmdList = new List <TransportCommand>();
myTransCmd = new TransportCommand();
myTransCmd = SearchModel();
var SubAccClientId = new SqlParameter();
var SubAccVendorId = new SqlParameter();
var CarId = new SqlParameter();
var ProductId = new SqlParameter();
var FromRegionId = new SqlParameter();
var ToRegionId = new SqlParameter();
var TransportType = new SqlParameter();
var PaymentWay = new SqlParameter();
//
if (myTransCmd.SubAccClientId != 0)
{
SubAccClientId = new SqlParameter("@SubAccClientId", myTransCmd.SubAccClientId);
}
else
{
SubAccClientId = new SqlParameter("@SubAccClientId", DBNull.Value);
}
//
if (myTransCmd.SubAccVendorId != 0)
{
SubAccVendorId = new SqlParameter("@SubAccVendorId", myTransCmd.SubAccVendorId);
}
else
{
SubAccVendorId = new SqlParameter("@SubAccVendorId", DBNull.Value);
}
//
if (myTransCmd.CarId != 0)
{
CarId = new SqlParameter("@CarId", myTransCmd.CarId);
}
else
{
CarId = new SqlParameter("@CarId", DBNull.Value);
}
//
if (myTransCmd.ProductId != "-1")
{
ProductId = new SqlParameter("@ProductId", myTransCmd.ProductId.Trim());
}
else
{
ProductId = new SqlParameter("@ProductId", DBNull.Value);
}
//
if (myTransCmd.FromRegionId != 0)
{
FromRegionId = new SqlParameter("@FromRegionId", myTransCmd.FromRegionId);
}
else
{
FromRegionId = new SqlParameter("@FromRegionId", DBNull.Value);
}
//
if (myTransCmd.ToRegionId != 0)
{
ToRegionId = new SqlParameter("@ToRegionId", myTransCmd.ToRegionId);
}
else
{
ToRegionId = new SqlParameter("@ToRegionId", DBNull.Value);
}
//
if (myTransCmd.TransportType != "اختار نوع النقل")
{
TransportType = new SqlParameter("@TransportType", myTransCmd.TransportType.Trim());
}
else
{
TransportType = new SqlParameter("@TransportType", DBNull.Value);
}
//
if (myTransCmd.PaymentWay != "اختار نوع الدفع")
{
PaymentWay = new SqlParameter("@PaymentWay", myTransCmd.PaymentWay.Trim());
}
else
{
PaymentWay = new SqlParameter("@PaymentWay", DBNull.Value);
}
TransCmdList = db.Database
.SqlQuery <TransportCommand>("SP_TransportCommand @SubAccClientId , @SubAccVendorId , @CarId , @ProductId , @FromRegionId , @ToRegionId , @TransportType , @PaymentWay"
, SubAccClientId, SubAccVendorId, CarId, ProductId, FromRegionId, ToRegionId, TransportType, PaymentWay).ToList();
SearchTransCmdList = TransCmdList;
BindGridList();
}
protected TransportCommand TransportCommandModel()
{
TransportCommand TransCmd = new TransportCommand();
try {
//DateTime CDate = DateTime.ParseExact(TransCmdDate.Text,
// "dd/MM/yyyy",
// CultureInfo.CreateSpecificCulture("ar-EG"));
if (TransCmdTxt.Text != "")
{
TransCmd.Id = Convert.ToInt32(TransCmdTxt.Text);
}
if (TransCmdDate.Text != "")
{
TransCmd.TransportCommandTime = DateTime.Parse(TransCmdDate.Text, CultureInfo.CreateSpecificCulture("ar-EG"));
}
if (SelectedSubAccClientId != "")
{
TransCmd.SubAccClientId = Convert.ToInt32(SelectedSubAccClientId);
}
}catch (Exception ex)
{
}
if (SelectedSubAccViendorId != "")
{
TransCmd.SubAccVendorId = Convert.ToInt32(SelectedSubAccViendorId);
}
if (SelectedCarsId != "")
{
TransCmd.CarId = Convert.ToInt32(SelectedCarsId);
}
if (SelectedProductId != "")
{
TransCmd.ProductId = SelectedProductId;
}
if (SelectedFromRegionId != "")
{
TransCmd.FromRegionId = Convert.ToInt32(SelectedFromRegionId);
}
if (SelectedToRegionId != "")
{
TransCmd.ToRegionId = Convert.ToInt32(SelectedToRegionId);
}
if (TransportPrice.Text != "")
{
TransCmd.TransportPrice = Convert.ToDouble(TransportPrice.Text);
}
if (Quantity.Text != "")
{
TransCmd.Quantity = Convert.ToDouble(Quantity.Text);
}
if (SelectedTransportTypeId != "")
{
TransCmd.TransportType = SelectedTransportTypeId;
}
if (TotalTransportPrice.Text != "")
{
TransCmd.TotalTransportPrice = Convert.ToDouble(TotalTransportPrice.Text);
}
if (SelectedPaymentWayId != "")
{
TransCmd.PaymentWay = SelectedPaymentWayId;
}
if (AtHour.Text != "")
{
TransCmd.TimeOfShipping = AtHour.Text;
}
TransCmd.LoginID = ExtendedMethod.GetUserData(User.Identity.Name).Id;
return(TransCmd);
}
